{"text_format":"2","workbook":"xlsx","n_sheets":76,"sheets":["History","동기화 배치목록","PR_ORD_M","PR_ORD_D","PR_BOOKCLUB_MEM_BILL_INFO","PR_EBOOK_KEPUB_PURCHASE_L","PR_EBOOK_KEPUB_DN_L","AUTHOR_PHOTO","DISPLAY_STATISTICS_DAY","DISPLAY_STATISTICS_WEEK","DISPLAY_STATISTICS_MONTH","DR_CARD_NEWS_GOODS_IMG","DR_EBOOK_BOOKCLUB_M","DR_EBOOK_FLAT_SELECT_ORDER_L","DR_EBOOK_GOODS_M","DR_EBOOK_SET_LIST","DR_EBOOK_Kepub_GOODS_D","DR_EBOOK_MEM_READ_M","DR_GOODS_ADD_D","DR_HASH_TAG_GOODS","DR_HASH_TAG_M","TSMDI03D","TSMBI01C","TSMBI02D","TSmdI01M","TSMGO01M","TSMGO04D","TSMGO06M","TSMGO07R","TSMGO08M","TSMGO09R","TSMGO11M","TSMGO12R","TSMGO32D","TSMGO35M","TSMGO40S","TSMGO82R","TSMME01M","GL_ART","GL_CATE","GL_CD","GL_CH_YES_WEBZINE_DOWN","TG_GL_EXPS_INFO","GL_GALY","GL_ITems","GL_LIBY","GL_RFRC_GB","GL_TAG","GL_TAG_LINK","GL_VW_YMD_SUM","GL_CLTE_EVE","IST24_CONTENT_INFO_T","IST24_CONTENT_LIST_INFO_T","IST24_GROUP_CONTENT_INFO_T","IST24_GROUP_CONTENT_MAPPING_T","IST24_MAIN_CONTENT_INFO_T","IST24_TAG_INFO_T","IST24_USER_MENU_INFO","IST24_WRITER_INFO_T","T_Code","T_ORDER_DETAIL","T_ORDER_MASTER","T_PERSON","TA_CODES","TA_MOVIE_RANK","TA_PLAY24_STAR_POINT_MST","TA_VOD_MENU","TA_VOD_MENU_MAPP","TA_VOD_MOBILE","TA_VOD_MOBILE_ENCODE","TA_VOD_MOBILE_GENRE","TA_VOD_ORIGINAL","TA_VOD_PHOTO","TA_VOD_STAFF","TA_M_DisplayContents","Sheet4"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"History","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,3,30,7],[29,3,29,7],[17,3,17,7],[25,3,25,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[2,1,2,8],[13,3,13,7],[14,3,14,7],[15,3,15,7],[16,3,16,7],[28,3,28,7],[27,3,27,7],[26,3,26,7],[18,3,18,7],[19,3,19,7]]}
[]
[]
[null,"인터페이스 설계서"]
{"$rows_empty":10}
[null,"개정이력","버전","개정 내역",{"$nulls":4},"작성자"]
[null,"2020-01-13","v0.1","최초 작성",{"$nulls":4},"이원도"]
[null,"2020-01-22","v0.3","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-01-29","v0.5","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-02-06","v0.9","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-02-12","v0.91","개정 및 현행화(TSMGO35M)",{"$nulls":4},"이원도"]
[null,"2020-02-13","v0.92","개정 및 현행화(PR_EBOOK_KEPUB_PURCHASE_L)",{"$nulls":4},"이원도"]
[null,"2020-02-20","v1.0","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-02-24","v1.1","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-04-13","v1.2","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-04-27","v1.3","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-05-15","v1.4","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-08-04","v1.5","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-08-18","v1.6","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-08-25","v1.7","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-08-27","v1.8","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-11-12","v2.0","개정 및 현행화",{"$nulls":4},"이원도"]
[null,"2020-11-26","v2.1","개정 및 현행화",{"$nulls":4},"이원도"]

{"sheet":"동기화 배치목록","index":1,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
["배치명","대상 Database","Source Table","Target Table"]
["구매 마스터","주문(Probe)","PR_ORD_M","TD_PR_ORD_M",null,null,null,{"$f":" \" desc \"&D3& \"; \"","v":" desc TD_PR_ORD_M; "}]
["구매 상세","주문(Probe)","PR_ORD_D","TD_PR_ORD_D",null,null,null,{"$f":" \" desc \"&D4& \"; \"","v":" desc TD_PR_ORD_D; "}]
["북클럽정액제 신청 테이블","주문(Probe)","PR_BOOKCLUB_MEM_BILL_INFO","TD_PR_BOOKCLUB_MEM_BILL_INFO",null,null,null," desc TD_PR_BOOKCLUB_MEM_BILL_INFO; "]
["전자책 매수 목록","주문(Probe)","PR_EBOOK_KEPUB_PURCHASE_L","TD_PR_EBOOK_KEPUB_PURCHASE_L",null,null,null," desc TD_PR_EBOOK_KEPUB_PURCHASE_L; "]
["전자책 다운로드 로그","주문(Probe)","PR_EBOOK_KEPUB_DN_L","TD_PR_EBOOK_KEPUB_DN_L",null,null,null," desc TD_PR_EBOOK_KEPUB_DN_L; "]
["작가이미지정보","상품(Drone)","AUTHOR_PHOTO","TD_AUTHOR_PHOTO",null,null,null," desc TD_AUTHOR_PHOTO; "]
["일별 베스트","상품(Drone)","DISPLAY_STATISTICS_DAY","TD_DISPLAY_STATISTICS_DAY",null,null,null," desc TD_DISPLAY_STATISTICS_DAY; "]
["주별 베스트","상품(Drone)","DISPLAY_STATISTICS_WEEK","TD_DISPLAY_STATISTICS_WEEK",null,null,null," desc TD_DISPLAY_STATISTICS_WEEK; "]
["월별 베스트","상품(Drone)","DISPLAY_STATISTICS_MONTH","TD_DISPLAY_STATISTICS_MONTH",null,null,null," desc TD_DISPLAY_STATISTICS_MONTH; "]
["카드뉴스이미지","상품(Drone)","DR_CARD_NEWS_GOODS_IMG","TD_DR_CARD_NEWS_GOODS_IMG",null,null,null," desc TD_DR_CARD_NEWS_GOODS_IMG; "]
["북클럽 마스터","상품(Drone)","DR_EBOOK_BOOKCLUB_M","TD_DR_EBOOK_BOOKCLUB_M",null,null,null," desc TD_DR_EBOOK_BOOKCLUB_M; "]
["나의 북클럽","상품(Drone)","DR_EBOOK_FLAT_SELECT_ORDER_L","TD_DR_EBOOK_FLAT_SELECT_ORDER_L",null,null,null," desc TD_DR_EBOOK_FLAT_SELECT_ORDER_L; "]
["이북 상품정보","상품(Drone)","DR_EBOOK_GOODS_M","TD_DR_EBOOK_GOODS_M",null,null,null," desc TD_DR_EBOOK_GOODS_M; "]
["한국이퍼브 전자책 정보","상품(Drone)","DR_EBOOK_Kepub_GOODS_D","TD_DR_EBOOK_Kepub_GOODS_D",null,null,null," desc TD_DR_EBOOK_Kepub_GOODS_D; "]
["이북 회원독서현황","상품(Drone)","DR_EBOOK_MEM_READ_M","TD_DR_EBOOK_MEM_READ_M",null,null,null," desc TD_DR_EBOOK_MEM_READ_M; "]
["ebook 세트 구성 정보","상품(Drone)","DR_EBOOK_SET_LIST","TD_DR_EBOOK_SET_LIST",null,null,null," desc TD_DR_EBOOK_SET_LIST; "]
["상품부가정보","상품(Drone)","DR_GOODS_ADD_D","TD_DR_GOODS_ADD_D",null,null,null," desc TD_DR_GOODS_ADD_D; "]
["상품별 해시태그 연결 정보","상품(Drone)","DR_HASH_TAG_GOODS","TD_DR_HASH_TAG_GOODS",null,null,null," desc TD_DR_HASH_TAG_GOODS; "]
["해시태그 키워드 마스터","상품(Drone)","DR_HASH_TAG_M","TD_DR_HASH_TAG_M",null,null,null," desc TD_DR_HASH_TAG_M; "]
["전시구성요소상세","상품(Drone)","TSMDI03D","TD_TSMDI03D",null,null,null," desc TD_TSMDI03D; "]
["코드마스터","회원(Scv)","TSMBI01C","TD_TSMBI01C",null,null,null," desc TD_TSMBI01C; "]
["코드상세","회원(Scv)","TSMBI02D","TD_TSMBI02D",null,null,null," desc TD_TSMBI02D; "]
["전시분류","상품(Drone)","TSmdI01M","TD_TSmdI01M",null,null,null," desc TD_TSmdI01M; "]
["상품","상품(Drone)","TSMGO01M","TD_TSMGO01M",null,null,null," desc TD_TSMGO01M; "]
["관리분류","상품(Drone)","TSMGO04D","TD_TSMGO04D",null,null,null," desc TD_TSMGO04D; "]
["상품Contents정보","상품(Drone)","TSMGO06M","TD_TSMGO06M",null,null,null," desc TD_TSMGO06M; "]
["상품Contents정보연결","상품(Drone)","TSMGO07R","TD_TSMGO07R",null,null,null," desc TD_TSMGO07R; "]
["작가정보","상품(Drone)","TSMGO08M","TD_TSMGO08M",null,null,null," desc TD_TSMGO08M; "]
["작가상품연결","상품(Drone)","TSMGO09R","TD_TSMGO09R",null,null,null," desc TD_TSMGO09R; "]
["상품파일정보","상품(Drone)","TSMGO11M","TD_TSMGO11M",null,null,null," desc TD_TSMGO11M; "]
["상품파일연결","상품(Drone)","TSMGO12R","TD_TSMGO12R",null,null,null," desc TD_TSMGO12R; "]
["관련상품","상품(Drone)","TSMGO32D","TD_TSMGO32D",null,null,null," desc TD_TSMGO32D; "]
["상품정보요약","상품(Drone)","TSMGO35M","TD_TSMGO35M",null,null,null," desc TD_TSMGO35M; "]
["상품별평점요약.리뷰","상품(Drone)","TSMGO40S","TD_TSMGO40S",null,null,null," desc TD_TSMGO40S; "]
["상품이러닝이북연결정보","상품(Drone)","TSMGO82R","TD_TSMGO82R",null,null,null," desc TD_TSMGO82R; "]
["회원정보","회원(Scv)","TSMME01M","TD_TSMME01M",null,null,null," desc TD_TSMME01M; "]
["채널예스아티클","예스채널(Goliath)","GL_ART","TG_GL_ART",null,null,null," desc TG_GL_ART; "]
["채널예스카테고리","예스채널(Goliath)","GL_CATE","TG_GL_CATE",null,null,null," desc TG_GL_CATE; "]
["채널예스공통코드","예스채널(Goliath)","GL_CD","TG_GL_CD",null,null,null," desc TG_GL_CD; "]
["웹진","예스채널(Goliath)","GL_CH_YES_WEBZINE_DOWN","TG_GL_CH_YES_WEBZINE_DOWN",null,null,null," desc TG_GL_CH_YES_WEBZINE_DOWN; "]
["채널확장정보","예스채널(Goliath)","GL_EXPS_INFO","TG_GL_EXPS_INFO",null,null,null," desc TG_GL_EXPS_INFO; "]
["갤러리","예스채널(Goliath)","GL_GALY","TG_GL_GALY",null,null,null," desc TG_GL_GALY; "]
["기사 아이템","예스채널(Goliath)","GL_ITems","TG_GL_ITems",null,null,null," desc TG_GL_ITems; "]
["명사의 서재","예스채널(Goliath)","GL_LIBY","TG_GL_LIBY",null,null,null," desc TG_GL_LIBY; "]
["RFRC 구분관리","예스채널(Goliath)","GL_RFRC_GB","TG_GL_RFRC_GB",null,null,null," desc TG_GL_RFRC_GB; "]
["채널 테그","예스채널(Goliath)","GL_TAG","TG_GL_TAG",null,null,null," desc TG_GL_TAG; "]
["채널테그연결","예스채널(Goliath)","GL_TAG_LINK","TG_GL_TAG_LINK",null,null,null," desc TG_GL_TAG_LINK; "]
["조회수통계","예스채널(Goliath)","GL_VW_YMD_SUM","TG_GL_VW_YMD_SUM",null,null,null," desc TG_GL_VW_YMD_SUM; "]
["문화행사","예스채널(Goliath)","GL_CLTE_EVE","TG_GL_CLTE_EVE",null,null,null," desc TG_GL_CLTE_EVE; "]
["스냅콘텐츠","스냅 (iStyle24)","IST24_CONTENT_INFO_T","TI_IST24_CONTENT_INFO_T",null,null,null," desc TI_IST24_CONTENT_INFO_T; "]
["스냅콘텐츠목록","스냅 (iStyle24)","IST24_CONTENT_LIST_INFO_T","TI_IST24_CONTENT_LIST_INFO_T",null,null,null," desc TI_IST24_CONTENT_LIST_INFO_T; "]
["콘텐츠 그룹","스냅 (iStyle24)","IST24_GROUP_CONTENT_INFO_T","TI_IST24_GROUP_CONTENT_INFO_T",null,null,null," desc TI_IST24_GROUP_CONTENT_INFO_T; "]
["콘텐츠 그룹 매핑","스냅 (iStyle24)","IST24_GROUP_CONTENT_MAPPING_T","TI_IST24_GROUP_CONTENT_MAPPING_T",null,null,null," desc TI_IST24_GROUP_CONTENT_MAPPING_T; "]
["스냅메인콘텐츠","스냅 (iStyle24)","IST24_MAIN_CONTENT_INFO_T","TI_IST24_MAIN_CONTENT_INFO_T",null,null,null," desc TI_IST24_MAIN_CONTENT_INFO_T; "]
["스냅테그정보","스냅 (iStyle24)","IST24_TAG_INFO_T","TI_IST24_TAG_INFO_T",null,null,null," desc TI_IST24_TAG_INFO_T; "]
["스냅메뉴정보","스냅 (iStyle24)","IST24_USER_MENU_INFO","TI_IST24_USER_MENU_INFO",null,null,null," desc TI_IST24_USER_MENU_INFO; "]
["스냅작가정보","스냅 (iStyle24)","IST24_WRITER_INFO_T","TI_IST24_WRITER_INFO_T",null,null,null," desc TI_IST24_WRITER_INFO_T; "]
["영화공통코드","play24(yesvod)","T_Code","TV_T_Code",null,null,null," desc TV_T_Code; "]
["영화구매마스터","play24(yesvod)","T_ORDER_DETAIL","TV_T_ORDER_DETAIL",null,null,null," desc TV_T_ORDER_DETAIL; "]
["영화구매상세","play24(yesvod)","T_ORDER_MASTER","TV_T_ORDER_MASTER",null,null,null," desc TV_T_ORDER_MASTER; "]
["영화인","play24(yesvod)","T_PERSON","TV_T_PERSON",null,null,null," desc TV_T_PERSON; "]
["영화코드","play24(yesvod)","TA_CODES","TV_TA_CODES",null,null,null," desc TV_TA_CODES; "]
["영화순위","play24(yesvod)","TA_MOVIE_RANK","TV_TA_MOVIE_RANK",null,null,null," desc TV_TA_MOVIE_RANK; "]
["영화 평점 테이블","play24(yesvod)","TA_PLAY24_STAR_POINT_MST","TV_TA_PLAY24_STAR_POINT_MST",null,null,null," desc TV_TA_PLAY24_STAR_POINT_MST; "]
["영화메뉴","play24(yesvod)","TA_VOD_MENU","TV_TA_VOD_MENU",null,null,null," desc TV_TA_VOD_MENU; "]
["영화메뉴 매핑","play24(yesvod)","TA_VOD_MENU_MAPP","TV_TA_VOD_MENU_MAPP",null,null,null," desc TV_TA_VOD_MENU_MAPP; "]
["스트리밍영화","play24(yesvod)","TA_VOD_MOBILE","TV_TA_VOD_MOBILE",null,null,null," desc TV_TA_VOD_MOBILE; "]
["스트리밍 영화 인코드","play24(yesvod)","TA_VOD_MOBILE_ENCODE","TV_TA_VOD_MOBILE_ENCODE",null,null,null," desc TV_TA_VOD_MOBILE_ENCODE; "]
["스트리밍영화장르","play24(yesvod)","TA_VOD_MOBILE_GENRE","TV_TA_VOD_MOBILE_GENRE",null,null,null,{"$f":" \" desc \"&D71& \"; \"","v":" desc TV_TA_VOD_MOBILE_GENRE; "}]
["스트리밍영화상품","play24(yesvod)","TA_VOD_ORIGINAL","TV_TA_VOD_ORIGINAL",null,null,null," desc TV_TA_VOD_ORIGINAL; "]
["스트리밍영화사진","play24(yesvod)","TA_VOD_PHOTO","TV_TA_VOD_PHOTO",null,null,null," desc TV_TA_VOD_PHOTO; "]
["스트리밍영화스탭","play24(yesvod)","TA_VOD_STAFF","TV_TA_VOD_STAFF",null,null,null," desc TV_TA_VOD_STAFF; "]
["메인배너 콘텐츠 디스플레이","play24(yesvod)","TA_M_DisplayContents","TV_TA_M_DisplayContents",null,null,null," desc TV_TA_M_DisplayContents; "]

{"sheet":"PR_ORD_M","index":2,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","주문 마스터"]
[null,"Source Database","PROBE","Target Database","story24"]
[null,"Sourse Table","PR_ORD_M","Target Table","TD_PR_ORD_M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"ord_no","int ","ord_no","int "]
[null,"ord_dts","datetime ","ord_dts","datetime(3)"]
[null,"ord_stat_gb","char(2) ","ord_stat_gb","char(2) "]
[null,"tot_ord_amt","decimal(14,2) ","tot_ord_amt","decimal(14,2) "]
[null,"tot_pay_plan_amt","decimal(14,2) ","tot_pay_plan_amt","decimal(14,2) "]
[null,"tot_pay_amt","decimal(14,2) ","tot_pay_amt","decimal(14,2) "]
[null,"tot_cncl_amt","decimal(14,2) ","tot_cncl_amt","decimal(14,2) "]
[null,"tot_goods_sale_amt","decimal(14,2) ","tot_goods_sale_amt","decimal(14,2) "]
[null,"dpay_yn","char(1) ","dpay_yn","char(1) "]
[null,"ref_plan_amt","decimal(14,2) ","ref_plan_amt","decimal(14,2) "]
[null,"tot_ref_amt","decimal(14,2) ","tot_ref_amt","decimal(14,2) "]
[null,"delv_fare","decimal(14,2) ","delv_fare","decimal(14,2) "]
[null,"pack_fare","decimal(14,2) ","pack_fare","decimal(14,2) "]
[null,"pack_cncl_fare","decimal(14,2) ","pack_cncl_fare","decimal(14,2) "]
[null,"ord_cncl_dts","datetime ","ord_cncl_dts","datetime(3)"]
[null,"delv_rep_res_point","int ","delv_rep_res_point","int "]
[null,"use_coup_no","int ","use_coup_no","int "]
[null,"pack_gb","char(2) ","pack_gb","char(2) "]
[null,"clm_occr_yn","char(1) ","clm_occr_yn","char(1) "]
[null,"pay_end_dts","datetime ","pay_end_dts","datetime(3)"]
[null,"ref_end_dts","datetime ","ref_end_dts","datetime(3)"]
[null,"rtn_delv_fare","decimal(14,2) ","rtn_delv_fare","decimal(14,2) "]
[null,"oamt_proc_stat_gb","char(2) ","oamt_proc_stat_gb","char(2) "]
[null,"ord_path_pid","varchar(60) ","ord_path_pid","varchar(60) "]
[null,"sale_log_no","int ","sale_log_no","int "]
[null,"settle_no","int ","settle_no","int "]
[null,"comb_ord_no","int ","comb_ord_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"ord_pay_stat_gb","char(2) ","ord_pay_stat_gb","char(2) "]
[null,"goods_tic_pwd","binary(20) ","goods_tic_pwd","binary(20) "]
[null,"txkey","int ","txkey","int "]
[null,"orgin_ord_no","int ","orgin_ord_no","int "]
[null,"delv_delay_eml_proc_yn","char(1) ","delv_delay_eml_proc_yn","char(1) "]
[null,"requestdeliverykey","int ","requestdeliverykey","int "]
[null,"cash_recpt_pub_yn","char(1) ","cash_recpt_pub_yn","char(1) "]
[null,"wh_last_delv_dts","datetime ","wh_last_delv_dts","datetime(3)"]
[null,"wh_potn_delv_yn","varchar(1) ","wh_potn_delv_yn","varchar(1) "]
[null,"ptr_mem_id","varchar(50) ","ptr_mem_id","varchar(50) "]
[null,"use_coup_pub_no","varchar(20) ","use_coup_pub_no","varchar(20) "]
[null,"point_card_no","varchar(20) ","point_card_no","varchar(20) "]
[null,"point_card_gb","char(2) ","point_card_gb","char(2) "]
[null,"ptr_add_point_rt","int ","ptr_add_point_rt","int "]
[null,"as_eml_proc_yn","char(1) ","as_eml_proc_yn","char(1) "]
[null,"corp_mem_gb","char(2) ","corp_mem_gb","char(2) "]
[null,"ginsr_appc_yn","char(1) ","ginsr_appc_yn","char(1) "]
[null,"ginsr_plcy_no","varchar(18) ","ginsr_plcy_no","varchar(18) "]
[null,"ptr_ord_id","varchar(50) ","ptr_ord_id","varchar(50) "]
[null,"ptr_mall_pay_gb","char(2) ","ptr_mall_pay_gb","char(2) "]
[null,"bef_use_coup_pub_no","varchar(20) ","bef_use_coup_pub_no","varchar(20) "]
[null,"bef_use_coup_no","int ","bef_use_coup_no","int "]
[null,"payment_affiliated_div","int ","payment_affiliated_div","int "]
[null,"mem_no","int ","mem_no","int "]
[null,"mem_id","varchar(50) ","mem_id","varchar(50) "]
[null,"mem_grade_gb","char(2) ","mem_grade_gb","char(2) "]
[null,"mem_gb","char(2) ","mem_gb","char(2) "]
[null,"idn_no","varchar(20) ","idn_no","varchar(20) "]
[null,"ordr_nm","varchar(50) ","ordr_nm","varchar(50) "]
[null,"ordr_telno","varchar(50) ","ordr_telno","varchar(50) "]
[null,"ordr_mob_telno","varchar(50) ","ordr_mob_telno","varchar(50) "]
[null,"ordr_eml","varchar(100) ","ordr_eml","varchar(100) "]
[null,"ord_conf_pwd","binary(20) ","ord_conf_pwd","binary(20) "]
[null,"delv_form_gb","char(2) ","delv_form_gb","char(2) "]
[null,"potn_delv_yn","char(1) ","potn_delv_yn","char(1) "]
[null,"wh_out_plan_dts","datetime ","wh_out_plan_dts","datetime(3)"]
[null,"ord_occr_gb","char(2) ","ord_occr_gb","char(2) "]
[null,"ord_gb","char(2) ","ord_gb","char(2) "]
[null,"ord_id","varchar(11)","ord_id","varchar(11)"]
[null,"deduction_yn","char(1) ","deduction_yn","char(1) "]

{"sheet":"PR_ORD_D","index":3,"n_rows":118,"n_cols":6,"rows_kept":118,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","주문 상세"]
[null,"Source Database","PROBE","Target Database","story24"]
[null,"Sourse Table","PR_ORD_D","Target Table","TD_PR_ORD_D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"ord_no","int ","ord_no","int "]
[null,"ord_seq","int ","ord_seq","int "]
[null,"cart_no","int ","cart_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"goods_seq","int ","goods_seq","int "]
[null,"goods_nm","varchar(200) ","goods_nm","varchar(200) "]
[null,"res_key_gb","char(2) ","res_key_gb","char(2) "]
[null,"disp_no","varchar(60) ","disp_no","varchar(60) "]
[null,"goods_sort_no","varchar(60) ","goods_sort_no","varchar(60) "]
[null,"goods_cost","decimal(14,2) ","goods_cost","decimal(14,2) "]
[null,"goods_gb","char(2) ","goods_gb","char(2) "]
[null,"sale_pr","decimal(14,2) ","sale_pr","decimal(14,2) "]
[null,"real_sale_pr","decimal(14,2) ","real_sale_pr","decimal(14,2) "]
[null,"no_int_quota_mon_cnt","int ","no_int_quota_mon_cnt","int "]
[null,"res_point_yn","char(1) ","res_point_yn","char(1) "]
[null,"res_point","int ","res_point","int "]
[null,"res_point_rt","int ","res_point_rt","int "]
[null,"delv_gap","tinyint ","delv_gap","tinyint unsigned"]
[null,"ord_cnt","int ","ord_cnt","int "]
[null,"delv_gb","char(2) ","delv_gb","char(2) "]
[null,"ord_cncl_cnt","int ","ord_cncl_cnt","int "]
[null,"mk_entr_no","int ","mk_entr_no","int "]
[null,"delv_entr_no","int ","delv_entr_no","int "]
[null,"delv_entr_nm","varchar(100) ","delv_entr_nm","varchar(100) "]
[null,"delv_cnt","int ","delv_cnt","int "]
[null,"rtn_cnt","int ","rtn_cnt","int "]
[null,"wh_out_not_dts","datetime ","wh_out_not_dts","datetime(3)"]
[null,"wh_out_end_dts","datetime ","wh_out_end_dts","datetime(3)"]
[null,"slip_no","varchar(20) ","slip_no","varchar(20) "]
[null,"clm_yn","char(1) ","clm_yn","char(1) "]
[null,"clm_gb","char(2) ","clm_gb","char(2) "]
[null,"eve_no","int ","eve_no","int "]
[null,"grd_goods_yn","char(1) ","grd_goods_yn","char(1) "]
[null,"grd_goods_no","int ","grd_goods_no","int "]
[null,"grd_goods_opt_no","int ","grd_goods_opt_no","int "]
[null,"ord_delv_stat_gb","char(2) ","ord_delv_stat_gb","char(2) "]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"ord_pay_stat_gb","char(2) ","ord_pay_stat_gb","char(2) "]
[null,"sup_entr_no","int ","sup_entr_no","int "]
[null,"sep_cart_yn","char(1) ","sep_cart_yn","char(1) "]
[null,"goods_wei","int ","goods_wei","int "]
[null,"grd_goods_ord_seq","int ","grd_goods_ord_seq","int "]
[null,"srv_coup_no","int ","srv_coup_no","int "]
[null,"txkey","int ","txkey","int "]
[null,"itemlistdeliverykey","int ","itemlistdeliverykey","int "]
[null,"delv_fare_yn","char(1) ","delv_fare_yn","char(1) "]
[null,"eve_grd_goods_ord_seq","int ","eve_grd_goods_ord_seq","int "]
[null,"wh_out_plan_dts","datetime ","wh_out_plan_dts","datetime(3)"]
[null,"wh_out_stat_gb","char(2) ","wh_out_stat_gb","char(2) "]
[null,"goods_stat_gb","char(2) ","goods_stat_gb","char(2) "]
[null,"add_cart_yn","char(1) ","add_cart_yn","char(1) "]
[null,"pack_yn","char(1) ","pack_yn","char(1) "]
[null,"assign_yn","char(1) ","assign_yn","char(1) "]
[null,"assign_cnt","int ","assign_cnt","int "]
[null,"last_assign_dts","datetime ","last_assign_dts","datetime(3)"]
[null,"tax_yn","char(1) ","tax_yn","char(1) "]
[null,"wh_out_eml_yn","char(1) ","wh_out_eml_yn","char(1) "]
[null,"as_eml_proc_yn","char(1) ","as_eml_proc_yn","char(1) "]
[null,"potn_delv_eml_yn","char(1) ","potn_delv_eml_yn","char(1) "]
[null,"goods_fea","varchar(100) ","goods_fea","varchar(100) "]
[null,"sub_ttl","varchar(200) ","sub_ttl","varchar(200) "]
[null,"goods_wh_rt","int ","goods_wh_rt","int "]
[null,"goods_wh_gb","char(2) ","goods_wh_gb","char(2) "]
[null,"mney_unt_gb","char(2) ","mney_unt_gb","char(2) "]
[null,"fix_exchrt_amt","decimal(14,2) ","fix_exchrt_amt","decimal(14,2) "]
[null,"shop_pr","decimal(14,2) ","shop_pr","decimal(14,2) "]
[null,"ws_pr","decimal(14,2) ","ws_pr","decimal(14,2) "]
[null,"goods_pr_dc_rt","int ","goods_pr_dc_rt","int "]
[null,"ord_lmt_yn","char(1) ","ord_lmt_yn","char(1) "]
[null,"set_goods_no","int ","set_goods_no","int "]
[null,"eve_goods_yn","char(1) ","eve_goods_yn","char(1) "]
[null,"coup_no","int ","coup_no","int "]
[null,"coup_pub_no","varchar(20) ","coup_pub_no","varchar(20) "]
[null,"coup_gb","char(2) ","coup_gb","char(2) "]
[null,"coup_use_amt","decimal(14,2) ","coup_use_amt","decimal(14,2) "]
[null,"set_goods_yn","char(1) ","set_goods_yn","char(1) "]
[null,"set_goods_qty","int ","set_goods_qty","int "]
[null,"set_goods_nm","varchar(200) ","set_goods_nm","varchar(200) "]
[null,"set_goods_sub_ttl","varchar(200) ","set_goods_sub_ttl","varchar(200) "]
[null,"set_goods_fea","varchar(100) ","set_goods_fea","varchar(100) "]
[null,"set_goods_srv_point","int ","set_goods_srv_point","int "]
[null,"set_goods_srv_point_rt","int ","set_goods_srv_point_rt","int "]
[null,"set_goods_sale_pr","decimal(14,2) ","set_goods_sale_pr","decimal(14,2) "]
[null,"set_goods_shop_pr","decimal(14,2) ","set_goods_shop_pr","decimal(14,2) "]
[null,"set_goods_pr_dc_rt","int ","set_goods_pr_dc_rt","int "]
[null,"ptr_add_point_rt","int ","ptr_add_point_rt","int "]
[null,"ocb_zpoint_real","int ","ocb_zpoint_real","int "]
[null,"goods_mng_md_no","int ","goods_mng_md_no","int "]
[null,"pay_dts","datetime ","pay_dts","datetime(3)"]
[null,"entr_delv_fare_yn","char(1) ","entr_delv_fare_yn","char(1) "]
[null,"ord_cncl_dts","datetime ","ord_cncl_dts","datetime(3)"]
[null,"ord_cncl_mng_no","int ","ord_cncl_mng_no","int "]
[null,"pla_entr_no","int ","pla_entr_no","int "]
[null,"first_arvl_delv_gb","char(2) ","first_arvl_delv_gb","char(2) "]
[null,"last_arvl_delv_gb","char(2) ","last_arvl_delv_gb","char(2) "]
[null,"exp_delv_arvl_dts","datetime ","exp_delv_arvl_dts","datetime(3)"]
[null,"last_delv_arvl_dts","datetime ","last_delv_arvl_dts","datetime(3)"]
[null,"wh_exp_delv_arvl_dts","datetime ","wh_exp_delv_arvl_dts","datetime(3)"]
[null,"aft_delv_fare_yn","char(1) ","aft_delv_fare_yn","char(1) "]
[null,"bfps_yn","char(1) ","bfps_yn","char(1) "]
[null,"set_bfps_yn","char(1) ","set_bfps_yn","char(1) "]
[null,"goods_fea2","varchar(100) ","goods_fea2","varchar(100) "]
[null,"set_goods_fea2","varchar(100) ","set_goods_fea2","varchar(100) "]
[null,"wh_code","varchar(3) ","wh_code","varchar(3) "]
[null,"ord_goods_remark","varchar(20) ","ord_goods_remark","varchar(20) "]
[null,"ndelv_rsn_desc","varchar(200) ","ndelv_rsn_desc","varchar(200) "]
[null,"min_pr_res_yn","char(1) ","min_pr_res_yn","char(1) "]
[null,"ocb_ZPOINT_DF","int ","ocb_ZPOINT_DF","int "]
[null,"set_res_key_gb","char(2) ","set_res_key_gb","char(2) "]
[null,"deduction_yn","char(1) ","deduction_yn","char(1) "]

{"sheet":"PR_BOOKCLUB_MEM_BILL_INFO","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","북클럽정액제 신청 테이블"]
[null,"Source Database","PROBE","Target Database","story24"]
[null,"Sourse Table","PR_BOOKCLUB_MEM_BILL_INFO","Target Table","TD_PR_BOOKCLUB_MEM_BILL_INFO"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"bookclub_pay_no","int","bookclub_pay_no","int"]
[null,"mem_no","int ","mem_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"goods_nm","varchar(200) ","goods_nm","varchar(200) "]
[null,"pay_info","varchar(10) ","pay_info","varchar(10) "]
[null,"ord_no","int ","ord_no","int "]
[null,"price","decimal(9) ","price","decimal(14,2)"]
[null,"mid","varchar(50) ","mid","varchar(50) "]
[null,"billkey","varchar(50) ","billkey","varchar(50) "]
[null,"bill_next_pay_date","datetime ","bill_next_pay_date","datetime(3)"]
[null,"bill_stat_gb","char(1) ","bill_stat_gb","char(1) "]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"use_start_dts","datetime ","use_start_dts","datetime(3)"]
[null,"use_end_dts","datetime ","use_end_dts","datetime(3)"]
[null,"pg_auth_date","varchar(8) ","pg_auth_date","varchar(8) "]
[null,"pg_auth_time","varchar(6) ","pg_auth_time","varchar(6) "]
[null,"reserve_goods_no","int ","reserve_goods_no","int "]
[null,"reserve_goods_nm","varchar(200) ","reserve_goods_nm","varchar(200) "]
[null,"reserve_pay_type","char(2) ","reserve_pay_type","char(2) "]
[null,"reserve_price","decimal(9) ","reserve_price","decimal(14,2)"]
[null,"ttbookclub","char(1) ","ttbookclub","char(1) "]
[null,"coup_pub_no","varchar(20) ","coup_pub_no","varchar(20) "]
[null,"platinum_yn","char(1) ","platinum_yn","char(1) "]
[null,"card_no","varchar(50) ","card_no","varchar(50) "]
[null,"card_code","varchar(2) ","card_code","char(2)"]

{"sheet":"PR_EBOOK_KEPUB_PURCHASE_L","index":5,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","전자책 매수 목록"]
[null,"Source Database","PROBE","Target Database","story24"]
[null,"Sourse Table","PR_EBOOK_KEPUB_PURCHASE_L","Target Table","TD_PR_EBOOK_KEPUB_PURCHASE_L"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"purchase_seq","int ","purchase_seq","int "]
[null,"mem_no","int ","mem_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"product_type","char(1) ","product_type","char(1) "]
[null,"product_code","int ","product_code","int "]
[null,"ebook_code","int ","ebook_code","int "]
[null,"ebook_id","varchar(64) ","ebook_id","varchar(64) "]
[null,"ord_no","int ","ord_no","int "]
[null,"sale_type","char(2) ","sale_type","char(2) "]
[null,"contents_type","char(2) ","contents_type","char(2) "]
[null,"file_size","int ","file_size","int "]
[null,"serial_num","int ","serial_num","int "]
[null,"ord_type","char(1) ","ord_type","char(1) "]
[null,"purchase_status","char(1) ","purchase_status","char(1) "]
[null,"ord_dt","varchar(50) ","ord_dt","varchar(50) "]
[null,"rent_dt","varchar(50) ","rent_dt","varchar(50) "]
[null,"rent_start_dt","varchar(50) ","rent_start_dt","varchar(50) "]
[null,"rent_end_dt","varchar(50) ","rent_end_dt","varchar(50) "]
[null,"display_status","char(1) ","display_status","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]

{"sheet":"PR_EBOOK_KEPUB_DN_L","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","전자책 다운로드 로그"]
[null,"Source Database","PROBE","Target Database","story24"]
[null,"Sourse Table","PR_EBOOK_KEPUB_DN_L","Target Table","TD_PR_EBOOK_KEPUB_DN_L"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"SEQ","int","SEQ","int"]
[null,"MEM_NO","int","MEM_NO","int"]
[null,"GOODS_NO","int","GOODS_NO","int"]
[null,"EBOOK_CODE","int","EBOOK_CODE","int"]
[null,"EBOOK_ID","varchar(64)","EBOOK_ID","varchar(64)"]
[null,"REG_DTS","datetime","REG_DTS","datetime(3)"]
[null,"UPT_DTS","datetime","UPT_DTS","datetime(3)"]
[null,"DN_CNT","int","DN_CNT","int"]
[null,"SALE_TYPE","int","SALE_TYPE","int"]

{"sheet":"AUTHOR_PHOTO","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,5],[5,1,5,2],[5,3,5,4],[5,5,6,5],[2,4,2,5],[3,4,3,5]]}
[]
[null,"배치 명","작가이미지정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","AUTHOR_PHOTO","Target Table","TD_AUTHOR_PHOTO"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"seq_no","int ","seq_no","int "]
[null,"auth_no","int ","auth_no","int "]
[null,"photo_nm","varchar(100) ","photo_nm","varchar(100) "]
[null,"photo_srv_path","varchar(100) ","photo_srv_path","varchar(100) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"disp_yn","char(1) ","disp_yn","char(1) "]
[null,"reg_mem_no","int ","reg_mem_no","int "]

{"sheet":"DISPLAY_STATISTICS_DAY","index":8,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","일별 베스트"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DISPLAY_STATISTICS_DAY","Target Table","TD_DISPLAY_STATISTICS_DAY"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"SALE_DTS","datetime","SALE_DTS","datetime"]
[null,"DISP_NO","varchar(60)","DISP_NO","varchar(60)"]
[null,"GOODS_NO","int","GOODS_NO","int"]
[null,"SUM_SEQ","int","SUM_SEQ","int"]

{"sheet":"DISPLAY_STATISTICS_WEEK","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","주별 베스트"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DISPLAY_STATISTICS_WEEK","Target Table","TD_DISPLAY_STATISTICS_WEEK"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"WEEK_NO","int","WEEK_NO","int"]
[null,"DISP_NO","varchar(60)","DISP_NO","varchar(60)"]
[null,"GOODS_NO","int","GOODS_NO","int"]
[null,"SUM_SEQ","int","SUM_SEQ","int"]
[null,"SUM_DTS","datetime","SUM_DTS","datetime"]

{"sheet":"DISPLAY_STATISTICS_MONTH","index":10,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","월별 베스트"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DISPLAY_STATISTICS_MONTH","Target Table","TD_DISPLAY_STATISTICS_MONTH"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"SALE_YEAR","smallint","SALE_YEAR","smallint"]
[null,"SALE_MONTH","tinyint","SALE_MONTH","tinyint"]
[null,"DISP_NO","varchar(60)","DISP_NO","varchar(60)"]
[null,"GOODS_NO","int","GOODS_NO","int"]
[null,"SUM_SEQ","int","SUM_SEQ","int"]

{"sheet":"DR_CARD_NEWS_GOODS_IMG","index":11,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","카드뉴스이미지"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_CARD_NEWS_GOODS_IMG","Target Table","TD_DR_CARD_NEWS_GOODS_IMG"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int"]
[null,"file_no","int ","file_no","int"]
[null,"card_news_seq","int ","card_news_seq","int"]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"upt_mng_no","int ","upt_mng_no","int"]

{"sheet":"DR_EBOOK_BOOKCLUB_M","index":12,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","북클럽 마스터"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_EBOOK_BOOKCLUB_M","Target Table","TD_DR_EBOOK_BOOKCLUB_M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"goods_nm","varchar(200) ","goods_nm","varchar(200) "]
[null,"ebook_code","int ","ebook_code","int "]
[null,"disp_no","varchar(60) ","disp_no","varchar(60) "]
[null,"srv_str_dts","datetime ","srv_str_dts","datetime(3)"]
[null,"srv_end_dts","datetime ","srv_end_dts","datetime(3)"]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"etc","text ","etc","text "]
[null,"disp_seq","int ","disp_seq","int "]
[null,"copy_pr","int ","copy_pr","int "]
[null,"mk_entr_nm","varchar(100) ","mk_entr_nm","varchar(100) "]
[null,"disp_sub_no","varchar(60) ","disp_sub_no","varchar(60) "]

{"sheet":"DR_EBOOK_FLAT_SELECT_ORDER_L","index":13,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","나의 북클럽"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_EBOOK_FLAT_SELECT_ORDER_L","Target Table","TD_DR_EBOOK_FLAT_SELECT_ORDER_L"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"ord_seq","int ","ord_seq","int "]
[null,"mem_no","int ","mem_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"ebook_code","int ","ebook_code","int "]
[null,"sale_type","int ","sale_type","int "]
[null,"rent_str_dts","datetime ","rent_str_dts","datetime(3)"]
[null,"rent_end_dts","datetime ","rent_end_dts","datetime(3)"]
[null,"return_dts","datetime ","return_dts","datetime(3)"]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]

{"sheet":"DR_EBOOK_GOODS_M","index":14,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","이북 상품정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_EBOOK_GOODS_M","Target Table","TD_DR_EBOOK_GOODS_M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"entr_no","int ","entr_no","int "]
[null,"entr_goods_no","int ","entr_goods_no","int "]
[null,"ebook_id","varchar(64) ","ebook_id","varchar(64) "]
[null,"book_goods_no","int ","book_goods_no","int "]
[null,"goods_man_no","varchar(20) ","goods_man_no","varchar(20) "]
[null,"goods_fee_rt","float ","goods_fee_rt","float "]
[null,"file_ext_gb","char(2) ","file_ext_gb","char(2) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]

{"sheet":"DR_EBOOK_SET_LIST","index":15,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","ebook 세트 구성 정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_EBOOK_SET_LIST","Target Table","TD_DR_EBOOK_SET_LIST"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"seq","int","seq","int"]
[null,"set_goods_no","int","set_goods_no","int"]
[null,"ebook_goods_no","int","ebook_goods_no","int"]
[null,"set_code","int","set_code","int"]
[null,"ebook_code","int","ebook_code","int"]
[null,"use_yn","varchar(1)","use_yn","varchar(1)"]
[null,"reg_dts","datetime","reg_dts","datetime(3)"]
[null,"upt_dts","datetime","upt_dts","datetime(3)"]

{"sheet":"DR_EBOOK_Kepub_GOODS_D","index":16,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","한국이퍼브 전자책 정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_EBOOK_Kepub_GOODS_D","Target Table","TD_DR_EBOOK_Kepub_GOODS_D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"file_ext_gb","char(2) ","file_ext_gb","char(2) "]
[null,"epub_id","int ","epub_id","int "]
[null,"ebook_id","varchar(64) ","ebook_id","varchar(64) "]
[null,"file_size","int ","file_size","int "]
[null,"perd_gb","char(2) ","perd_gb","char(2) "]
[null,"pev_yn","char(1) ","pev_yn","char(1) "]
[null,"pev_URL","varchar(512) ","pev_URL","varchar(512) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"sale_type","varchar(2) ","sale_type","varchar(2) "]
[null,"ebook_code","int ","ebook_code","int "]
[null,"rent_term","int ","rent_term","int "]
[null,"rent_price","numeric(9) ","rent_price","decimal(14,2)"]
[null,"tts_yn","varchar(1) ","tts_yn","char(1)"]
[null,"char_cnt","int ","char_cnt","int "]
[null,"page_cnt","int ","page_cnt","int "]
[null,"word_cnt","int ","word_cnt","int "]
[null,"flat_rate_yn","char(1) ","flat_rate_yn","char(1) "]
[null,"kepub_cal_cd","varchar(20) ","kepub_cal_cd","varchar(20) "]
[null,"kepub_cal_nm","varchar(100) ","kepub_cal_nm","varchar(100) "]
[null,"read_dir","int ","read_dir","int "]
[null,"lang","char(2) ","lang","char(2) "]
[null,"contents_type","varchar(20) ","contents_type","varchar(20) "]
[null,"contents_subtype","int ","contents_subtype","int "]
[null,"cdn_reg_dts","datetime ","cdn_reg_dts","datetime(3)"]
[null,"cdn_upt_dts","datetime ","cdn_upt_dts","datetime(3)"]

{"sheet":"DR_EBOOK_MEM_READ_M","index":17,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","이북 회원독서현황"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_EBOOK_MEM_READ_M","Target Table","TD_DR_EBOOK_MEM_READ_M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"read_seq","int ","read_seq","int "]
[null,"mem_no","int ","mem_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"ebook_code","int ","ebook_code","int "]
[null,"read_last_percent","int ","read_last_percent","int "]
[null,"read_finish_cnt","int ","read_finish_cnt","int "]
[null,"read_finish_yn","char(1) ","read_finish_yn","char(1) "]
[null,"sale_type","int ","sale_type","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]

{"sheet":"DR_GOODS_ADD_D","index":18,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품부가정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_GOODS_ADD_D","Target Table","TD_DR_GOODS_ADD_D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"optn_ins_yn","char(1) ","optn_ins_yn","char(1) "]
[null,"ord_cncl_fee_rt","int ","ord_cncl_fee_rt","int "]
[null,"kwch_kwje_nm","varchar(200) ","kwch_kwje_nm","varchar(200) "]
[null,"pnhg_gb","char(2) ","pnhg_gb","char(2) "]
[null,"cnfg_splm_gb","char(2) ","cnfg_splm_gb","char(2) "]
[null,"cnfg_splm_cnt","int ","cnfg_splm_cnt","int "]
[null,"pnch_gb","char(2) ","pnch_gb","char(2) "]
[null,"eout_impb_yn","char(1) ","eout_impb_yn","char(1) "]
[null,"b2b_sale_psbl_yn","char(1) ","b2b_sale_psbl_yn","char(1) "]
[null,"file_cap","int ","file_cap","int "]
[null,"file_form_nm","varchar(20) ","file_form_nm","varchar(20) "]
[null,"papr_book_pub_dts","datetime ","papr_book_pub_dts","datetime(3)"]
[null,"lstn_kind_gb","char(2) ","lstn_kind_gb","char(2) "]
[null,"tcmt_goods_no","int ","tcmt_goods_no","int "]
[null,"bkbn_mthd_gb","char(2) ","bkbn_mthd_gb","char(2) "]
[null,"mob_exus_lctr_yn","char(1) ","mob_exus_lctr_yn","char(1) "]
[null,"b2c_sup_rt","int ","b2c_sup_rt","int "]
[null,"b2b2c_sup_rt","int ","b2b2c_sup_rt","int "]
[null,"last_wh_in_dts","datetime ","last_wh_in_dts","datetime(3)"]
[null,"last_wh_in_rt","int ","last_wh_in_rt","int "]
[null,"last_wh_in_cost","int ","last_wh_in_cost","int "]
[null,"last_rtn_dts","datetime ","last_rtn_dts","datetime(3)"]
[null,"rtn_yn","char(1) ","rtn_yn","char(1) "]
[null,"rtn_desc","varchar(500) ","rtn_desc","varchar(500) "]
[null,"delv_entr_no","int ","delv_entr_no","int "]
[null,"org_tran_gb","char(2) ","org_tran_gb","char(2) "]
[null,"y_last_wh_in_dts","datetime ","y_last_wh_in_dts","datetime(3)"]
[null,"y_last_wh_in_rt","int ","y_last_wh_in_rt","int "]
[null,"y_last_wh_in_cost","int ","y_last_wh_in_cost","int "]
[null,"cremney_dc_gb","char(1) ","cremney_dc_gb","char(1) "]
[null,"cremney_dc_amt","int ","cremney_dc_amt","int "]
[null,"book_isbn","varchar(13) ","book_isbn","varchar(13) "]
[null,"ecn","varchar(32) ","ecn","varchar(32) "]
[null,"gift_ad_yn","char(1) ","gift_ad_yn","char(1) "]
[null,"group_purchase_yn","char(1) ","group_purchase_yn","char(1) "]
[null,"global_sale_yn","char(1) ","global_sale_yn","char(1) "]
[null,"deduction_yn","char(1) ","deduction_yn","char(1) "]

{"sheet":"DR_HASH_TAG_GOODS","index":19,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품별 해시태그 연결 정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_HASH_TAG_GOODS","Target Table","TD_DR_HASH_TAG_GOODS"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"hash_no","int ","hash_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"hash_seq","int ","hash_seq","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"upt_mng_no","int ","upt_mng_no","int "]

{"sheet":"DR_HASH_TAG_M","index":20,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","해시태그 키워드 마스터"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","DR_HASH_TAG_M","Target Table","TD_DR_HASH_TAG_M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"hash_no","int ","hash_no","int "]
[null,"hash_nm","varchar(200) ","hash_nm","varchar(200) "]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"hash_gb","char(2)","hash_gb","char(2)"]

{"sheet":"TSMDI03D","index":21,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품별 전시분류"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMDI03D","Target Table","TD_TSMDI03D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"disp_no","varchar(60) ","disp_no","varchar(60)"]
[null,"elem_no","int ","elem_no","int"]
[null,"elem_seq","int ","elem_seq","int"]
[null,"elem_dtl_no","int ","elem_dtl_no","int"]
[null,"unt_no","int ","unt_no","int"]
[null,"unt_seq","int ","unt_seq","int"]
[null,"disp_prir","smallint ","disp_prir","smallint"]
[null,"use_yn","char(1) ","use_yn","char(1)"]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int"]
[null,"upt_mng_no","int ","upt_mng_no","int"]
[null,"h1_disp_no","varchar(60) ","h1_disp_no","varchar(60)"]
[null,"h2_disp_no","varchar(60) ","h2_disp_no","varchar(60)"]
[null,"h3_disp_no","varchar(60) ","h3_disp_no","varchar(60)"]

{"sheet":"TSMBI01C","index":22,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","코드마스터"]
[null,"Source Database","SCV","Target Database","story24"]
[null,"Sourse Table","TSMBI01C","Target Table","TD_TSMBI01C"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"cd_no","varchar(3) ","cd_no","varchar(3) "]
[null,"cd_nm","varchar(100) ","cd_nm","varchar(100) "]
[null,"cd_desc","varchar(200) ","cd_desc","varchar(200) "]
[null,"sys_cd_yn","char(1) ","sys_cd_yn","char(1) "]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]

{"sheet":"TSMBI02D","index":23,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","코드상세"]
[null,"Source Database","SCV","Target Database","story24"]
[null,"Sourse Table","TSMBI02D","Target Table","TD_TSMBI02D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"cd_no","varchar(3) ","cd_no","varchar(3) "]
[null,"cd_dtl_no","varchar(3) ","cd_dtl_no","varchar(3) "]
[null,"cd_dtl_nm","varchar(100) ","cd_dtl_nm","varchar(100) "]
[null,"cd_dtl_desc","VARCHAR(8000)","cd_dtl_desc","varchar(1000)"]
[null,"disp_prir","tinyint ","disp_prir","tinyint unsigned"]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]

{"sheet":"TSmdI01M","index":24,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","전시분류"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSmdI01M","Target Table","TD_TSmdI01M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"disp_no","varchar(60) ","disp_no","varchar(60) "]
[null,"disp_nm","varchar(100) ","disp_nm","varchar(100) "]
[null,"disp_gb","varchar(2) ","disp_gb","char(2)"]
[null,"disp_prir","INTEGER","disp_prir","tinyint unsigned"]
[null,"high_cate_no","varchar(60) ","high_cate_no","varchar(60) "]
[null,"cate_dep","int ","cate_dep","int "]
[null,"sub_cate_cnt","int ","sub_cate_cnt","int "]
[null,"sub_goods_cnt","int ","sub_goods_cnt","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"disp_path_nm","varchar(250) ","disp_path_nm","varchar(250) "]
[null,"sum_yn","char(1) ","sum_yn","char(1) "]
[null,"disp_cnt","int ","disp_cnt","int "]
[null,"entr_no","int ","entr_no","int "]
[null,"cate_lnb_yn","CHAR(1)","cate_lnb_yn","CHAR(1)"]

{"sheet":"TSMGO01M","index":25,"n_rows":154,"n_cols":6,"rows_kept":154,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO01M","Target Table","TD_TSMGO01M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"goods_nm","varchar(200) ","goods_nm","varchar(200) "]
[null,"sub_ttl","varchar(200) ","sub_ttl","varchar(200) "]
[null,"orgin_ttl","varchar(200) ","orgin_ttl","varchar(200) "]
[null,"goods_auth","varchar(120) ","goods_auth","varchar(120) "]
[null,"res_key_gb","varchar(2) ","res_key_gb","char(2)"]
[null,"goods_sort_no","varchar(60) ","goods_sort_no","varchar(60) "]
[null,"goods_md","int ","goods_md","int "]
[null,"mag_no","int ","mag_no","int "]
[null,"goods_gb","varchar(2) ","goods_gb","char(2)"]
[null,"mk_entr_no","int ","mk_entr_no","int "]
[null,"mk_entr_nm","varchar(100) ","mk_entr_nm","varchar(100) "]
[null,"sup_entr_no","int ","sup_entr_no","int "]
[null,"sup_entr_nm","varchar(100) ","sup_entr_nm","varchar(100) "]
[null,"pla_entr_no","int ","pla_entr_no","int "]
[null,"pla_entr_mn","varchar(100) ","pla_entr_mn","varchar(100) "]
[null,"shop_pr","numeric(14,2) ","shop_pr","decimal(14,2)"]
[null,"sale_pr","numeric(14,2) ","sale_pr","decimal(14,2)"]
[null,"disc_rt","int ","disc_rt","int "]
[null,"point_rt","int ","point_rt","int "]
[null,"srv_point","int ","srv_point","int "]
[null,"goods_cost","numeric(14,2) ","goods_cost","decimal(14,2)"]
[null,"goods_wh_rt","int ","goods_wh_rt","int "]
[null,"goods_wh_gb","varchar(2) ","goods_wh_gb","varchar(2) "]
[null,"ws_pr","numeric(14,2) ","ws_pr","decimal(14,2)"]
[null,"ean","varchar(30) ","ean","varchar(30) "]
[null,"iss_dm","varchar(8) ","iss_dm","varchar(8) "]
[null,"man_no","varchar(30) ","man_no","varchar(30) "]
[null,"goods_stat_gb","varchar(2) ","goods_stat_gb","char(2)"]
[null,"goods_quan","int ","goods_quan","int "]
[null,"goods_wei","int ","goods_wei","int "]
[null,"goods_hei","int ","goods_hei","int "]
[null,"goods_wid","int ","goods_wid","int "]
[null,"goods_len","int ","goods_len","int "]
[null,"cap_wei","int ","cap_wei","int "]
[null,"goods_fea","varchar(100) ","goods_fea","varchar(100) "]
[null,"edi_memo","varchar(100) ","edi_memo","varchar(100) "]
[null,"man_memo","text","man_memo","text"]
[null,"age_lmt_yn","char(1) ","age_lmt_yn","char(1) "]
[null,"lmt_age","int ","lmt_age","int "]
[null,"rec_gb","varchar(2) ","rec_gb","char(2)"]
[null,"sear_yn","char(1) ","sear_yn","char(1) "]
[null,"add_cart_yn","char(1) ","add_cart_yn","char(1) "]
[null,"pack_yn","char(1) ","pack_yn","char(1) "]
[null,"delv_fare_yn","char(1) ","delv_fare_yn","char(1) "]
[null,"oversea_del_yn","char(1) ","oversea_del_yn","char(1) "]
[null,"mon_unt_gb","varchar(2) ","mon_unt_gb","char(2)"]
[null,"fix_exc_rat_amt","numeric(14,2) ","fix_exc_rat_amt","decimal(14,2)"]
[null,"show_yn","char(1) ","show_yn","char(1) "]
[null,"delv_gb","varchar(2) ","delv_gb","char(2)"]
[null,"imp_gb","varchar(2) ","imp_gb","char(2)"]
[null,"agr_yn","char(1) ","agr_yn","char(1) "]
[null,"file_yn","char(1) ","file_yn","char(1) "]
[null,"tax_yn","char(1) ","tax_yn","char(1) "]
[null,"hand_delv_yn","char(1) ","hand_delv_yn","char(1) "]
[null,"fit_sto_hand_yn","char(1) ","fit_sto_hand_yn","char(1) "]
[null,"sep_cart_yn","char(1) ","sep_cart_yn","char(1) "]
[null,"max_amt_per_ord","int ","max_amt_per_ord","int"]
[null,"delv_gap","INTEGER","delv_gap","tinyint unsigned"]
[null,"abs_auto_cls_yn","char(1) ","abs_auto_cls_yn","char(1) "]
[null,"goods_opt_yn","char(1) ","goods_opt_yn","char(1) "]
[null,"ord_lmt_yn","char(1) ","ord_lmt_yn","char(1) "]
[null,"grd_goods_no","int ","grd_goods_no","int "]
[null,"grd_goods_opt_no","int ","grd_goods_opt_no","int "]
[null,"coup_no","int ","coup_no","int "]
[null,"tot_wh_amt","numeric(14,2) ","tot_wh_amt","decimal(14,2)"]
[null,"tot_wh_cnt","int ","tot_wh_cnt","int "]
[null,"avg_cost","numeric(14,2) ","avg_cost","decimal(14,2)"]
[null,"no_int_quota_mon","int ","no_int_quota_mon","int "]
[null,"last_cost","numeric(14,2) ","last_cost","decimal(14,2)"]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"pur_yn","char","pur_yn","char"]
[null,"sale_sco","int ","sale_sco","int "]
[null,"ocb_point","numeric(14,2)(14,2) ","ocb_point","decimal(14,2)"]
[null,"mania_point","char(1)(1) ","mania_point","char(1)(1) "]
[null,"sale_will_dts","DATETIME","sale_will_dts","datetime(3)"]
[null,"cap_wei_temp","int ","cap_wei_temp","int "]
[null,"mjr_goods_no","int ","mjr_goods_no","int "]
[null,"audio_sample","varchar(50) ","audio_sample","varchar(50) "]
[null,"audio_book","varchar(50) ","audio_book","varchar(50) "]
[null,"brand_no","int ","brand_no","int "]
[null,"assign_yn","char(1) ","assign_yn","char(1) "]
[null,"dcoup_no","int ","dcoup_no","int "]
[null,"dcoup_str_dts","datetime ","dcoup_str_dts","datetime(3)"]
[null,"dcoup_end_dts","datetime ","dcoup_end_dts","datetime(3)"]
[null,"rec_yn","char(1) ","rec_yn","char(1) "]
[null,"rel_yn","char(1) ","rel_yn","char(1) "]
[null,"seri_yn","char(1) ","seri_yn","char(1) "]
[null,"lic_gb","char(1) ","lic_gb","char(1) "]
[null,"soldout_dts","datetime ","soldout_dts","datetime(3)"]
[null,"auto_lmt_yn","char(1) ","auto_lmt_yn","char(1) "]
[null,"mail_yn","char(1) ","mail_yn","char(1) "]
[null,"dcoup_disp_yn","char(1) ","dcoup_disp_yn","char(1) "]
[null,"set_yn","char(1) ","set_yn","char(1) "]
[null,"sort_dts","datetime ","sort_dts","datetime(3)"]
[null,"sort_gb","char(2) ","sort_gb","char(2) "]
[null,"blink_yn","char(1) ","blink_yn","char(1) "]
[null,"set_sum_yn","char(1) ","set_sum_yn","char(1) "]
[null,"trans_book_no","int ","trans_book_no","int "]
[null,"ocb_zpoint","int ","ocb_zpoint","int "]
[null,"ocb_zpoint_sta_dts","DATETIME","ocb_zpoint_sta_dts","datetime(3)"]
[null,"ocb_zpoint_end_dts","DATETIME","ocb_zpoint_end_dts","datetime(3)"]
[null,"ebook_yn","char(1) ","ebook_yn","char(1) "]
[null,"ubook_pda_yn","char(1) ","ubook_pda_yn","char(1) "]
[null,"ubook_pc_yn","char(1) ","ubook_pc_yn","char(1) "]
[null,"ubook_hphone_yn","char(1) ","ubook_hphone_yn","char(1) "]
[null,"complex_order_yn","char(1) ","complex_order_yn","char(1) "]
[null,"sup_delay_yn","char(1) ","sup_delay_yn","char(1) "]
[null,"review_allow_yn","char(1) ","review_allow_yn","char(1) "]
[null,"rev_del_msg_yn","char(1) ","rev_del_msg_yn","char(1) "]
[null,"entr_delv_fare_yn","char(1) ","entr_delv_fare_yn","char(1) "]
[null,"ean2","varchar(30) ","ean2","varchar(30) "]
[null,"notify_yn","char(1) ","notify_yn","char(1) "]
[null,"notify_min_cnt","tinyint ","notify_min_cnt","tinyint unsigned"]
[null,"revision_goods_no","int ","revision_goods_no","int "]
[null,"delv_gap_manual_yn","char(1) ","delv_gap_manual_yn","char(1) "]
[null,"unassign_memo","varchar(30) ","unassign_memo","varchar(30) "]
[null,"unassign_ord_req_yn","char(1) ","unassign_ord_req_yn","char(1) "]
[null,"exp_indate","smalldatetime ","exp_indate","datetime"]
[null,"unassign_upt_dts","datetime ","unassign_upt_dts","datetime(3)"]
[null,"charge_collect_yn","char(1) ","charge_collect_yn","char(1) "]
[null,"rsv_disp_yn","char(1) ","rsv_disp_yn","char(1) "]
[null,"newbook_yn","char(1) ","newbook_yn","char(1) "]
[null,"rsv_yespoint","int ","rsv_yespoint","int "]
[null,"special_set_show_yn","char(1) ","special_set_show_yn","char(1) "]
[null,"orgin_goods_no","int ","orgin_goods_no","int "]
[null,"poster_bullet_yn","char(1) ","poster_bullet_yn","char(1) "]
[null,"md_comment","varchar(100) ","md_comment","varchar(100) "]
[null,"goods_fea2","varchar(100) ","goods_fea2","varchar(100) "]
[null,"use_term_gb","varchar(2) ","use_term_gb","char(2)"]
[null,"minidas_not_use_yn","char(1) ","minidas_not_use_yn","char(1) "]
[null,"foreign_goods_cost","numeric(14,2) ","foreign_goods_cost","decimal(14,2)"]
[null,"foreign_shop_pr","numeric(14,2) ","foreign_shop_pr","decimal(14,2)"]
[null,"read_yn","char(1) ","read_yn","char(1) "]
[null,"sale_will_popup_yn","char(1) ","sale_will_popup_yn","char(1) "]
[null,"lapping_yn","char(1) ","lapping_yn","char(1) "]
[null,"youngnam_logistics_yn","char(1) ","youngnam_logistics_yn","char(1) "]
[null,"edi_memo_disp_yn","char(1) ","edi_memo_disp_yn","char(1) "]
[null,"display_sale_will_dts","DATETIME","display_sale_will_dts","datetime(3)"]
[null,"buy_agency_yn","char(1) ","buy_agency_yn","char(1) "]
[null,"oldbook_disc_yn","char(1) ","oldbook_disc_yn","char(1) "]
[null,"no_int_quota_from_dts","datetime ","no_int_quota_from_dts","datetime(3)"]
[null,"no_int_quota_to_dts","datetime ","no_int_quota_to_dts","datetime(3)"]

{"sheet":"TSMGO04D","index":26,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","관리분류"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO04D","Target Table","TD_TSMGO04D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_sort_no","varchar(60) ","goods_sort_no","varchar(60) "]
[null,"goods_sort_nm","varchar(100) ","goods_sort_nm","varchar(100) "]
[null,"mng_md_no","int ","mng_md_no","int "]
[null,"disp_zone","varchar(3) ","disp_zone","varchar(3) "]
[null,"use_yn","char(1) ","use_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"goods_mng_md_no","int ","goods_mng_md_no","int "]
[null,"disp_seq","int ","disp_seq","int "]

{"sheet":"TSMGO06M","index":27,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품Contents정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO06M","Target Table","TD_TSMGO06M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"cont_no","int ","cont_no","int "]
[null,"cont_gb","varchar(2) ","cont_gb","char(2)"]
[null,"cont_ttl","varchar(200) ","cont_ttl","varchar(200) "]
[null,"cont_sou","varchar(200) ","cont_sou","varchar(200) "]
[null,"writ_intr","MEDIUMTEXT","writ_intr","MEDIUMTEXT"]
[null,"writ_dm","datetime ","writ_dm","datetime(3)"]
[null,"cont","MEDIUMTEXT","cont","MEDIUMTEXT"]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"media_gb","varchar(4) ","media_gb","varchar(4) "]
[null,"html_yn","char(1) ","html_yn","char(1) "]
[null,"md_advice","varchar(100) ","md_advice","varchar(440)"]
[null,"disp_prir","INTEGER","disp_prir","tinyint unsigned"]
[null,"auth_gb","char(2) ","auth_gb","char(2) "]
[null,"web_video_URL","varchar(200) ","web_video_URL","varchar(200) "]
[null,"web_img_path_nm","varchar(200) ","web_img_path_nm","varchar(200) "]
[null,"mob_video_URL","varchar(200) ","mob_video_URL","varchar(200) "]
[null,"mob_img_path_nm","varchar(200) ","mob_img_path_nm","varchar(200) "]

{"sheet":"TSMGO07R","index":28,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품Contents정보연결"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO07R","Target Table","TD_TSMGO07R"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"cont_no","int ","cont_no","int "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"use_yn","char(1) ","use_yn","char(1) "]

{"sheet":"TSMGO08M","index":29,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","작가정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO08M","Target Table","TD_TSMGO08M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"auth_no","int ","auth_no","int "]
[null,"auth_nm","varchar(100) ","auth_nm","varchar(100) "]
[null,"int_auth_nm","text","int_auth_nm","mediumtext"]
[null,"ext_auth_nm","varchar(150) ","ext_auth_nm","varchar(150) "]
[null,"auth_rec","text","auth_rec","mediumtext"]
[null,"auth_det","text","auth_det","mediumtext"]
[null,"awd_rec","text","awd_rec","mediumtext"]
[null,"auth_img_file_no","int ","auth_img_file_no","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3)"]
[null,"upt_dts","datetime ","upt_dts","datetime(3)"]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"auth_gb","varchar(2) ","auth_gb","char(2)"]
[null,"key_yn","char(1) ","key_yn","char(1) "]
[null,"auth_domain_gb","varchar(2) ","auth_domain_gb","char(2)"]
[null,"auth_birthday","varchar(8) ","auth_birthday","varchar(8) "]
[null,"auth_region","varchar(2) ","auth_region","char(2)"]
[null,"auth_sect","varchar(2) ","auth_sect","char(2)"]
[null,"man_memo","text","man_memo","mediumtext"]
[null,"res_key_gb","varchar(2) ","res_key_gb","char(2)"]
[null,"strt_goods_no","int ","strt_goods_no","int "]
[null,"strt_goods_nm","varchar(50) ","strt_goods_nm","varchar(50) "]
[null,"auth_home","varchar(200) ","auth_home","varchar(200) "]
[null,"auth_eml","varchar(100) ","auth_eml","varchar(100) "]
[null,"rel_URL1","varchar(200) ","rel_URL1","varchar(200) "]
[null,"rel_URL2","varchar(200) ","rel_URL2","varchar(200) "]
[null,"rel_URL3","varchar(200) ","rel_URL3","varchar(200) "]
[null,"auth_blog","varchar(200) ","auth_blog","varchar(200) "]
[null,"auth_death","varchar(8) ","auth_death","varchar(8) "]
[null,"nat_nm","varchar(50) ","nat_nm","varchar(50) "]
[null,"sex","char(1) ","sex","char(1) "]
[null,"job","varchar(50) ","job","varchar(50) "]
[null,"auth_img_sou","varchar(50) ","auth_img_sou","varchar(50) "]
[null,"auth_img_yn","char(1) ","auth_img_yn","char(1) "]
[null,"ext_auth_nm1","varchar(150) ","ext_auth_nm1","varchar(150) "]
[null,"ext_auth_nm2","varchar(150) ","ext_auth_nm2","varchar(150) "]
[null,"ext_auth_nm3","varchar(150) ","ext_auth_nm3","varchar(150) "]
[null,"author_recommend_yn","char(1) ","author_recommend_yn","char(1) "]
[null,"prir_disp_yn","char(1) ","prir_disp_yn","char(1) "]
[null,"auth_img_origin","varchar(50) ","auth_img_origin","varchar(50) "]
[null,"interest_auth_yn","char(1) ","interest_auth_yn","char(1) "]
[null,"auth_det_origin","varchar(50) ","auth_det_origin","varchar(50) "]

{"sheet":"TSMGO09R","index":30,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","작가상품연결"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO09R","Target Table","TD_TSMGO09R"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"auth_no","int ","auth_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"rel_gb","varchar(2) ","rel_gb","varchar(2) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]

{"sheet":"TSMGO11M","index":31,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품파일정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO11M","Target Table","TD_TSMGO11M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"file_no","int ","file_no","int "]
[null,"file_exp_nm","varchar(50) ","file_exp_nm","varchar(50) "]
[null,"anch_nm","varchar(150) ","anch_nm","varchar(150) "]
[null,"file_gb","varchar(2) ","file_gb","char(2)"]
[null,"file_kind_gb","varchar(2) ","file_kind_gb","char(2)"]
[null,"file_desc","varchar(250) ","file_desc","varchar(250) "]
[null,"serv_file_nm","varchar(50) ","serv_file_nm","varchar(50) "]
[null,"serv_file_path","varchar(200) ","serv_file_path","varchar(200) "]
[null,"usr_file_nm","varchar(200) ","usr_file_nm","varchar(200) "]
[null,"img_wid","int ","img_wid","int "]
[null,"img_height","int ","img_height","int "]
[null,"file_vol","int ","file_vol","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]

{"sheet":"TSMGO12R","index":32,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품파일연결"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO12R","Target Table","TD_TSMGO12R"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"file_no","int ","file_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"file_gb","varchar(2) ","file_gb","varchar(2) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"use_yn","char(1) ","use_yn","char(1) "]

{"sheet":"TSMGO32D","index":33,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","관련상품"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO32D","Target Table","TD_TSMGO32D"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"rel_goods_no","int ","rel_goods_no","int "]
[null,"rel_gb","varchar(2) ","rel_gb","char(2)"]
[null,"prior","int ","prior","int "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_mng_no","int ","upt_mng_no","int "]
[null,"use_yn","char(1) ","use_yn","char(1) "]

{"sheet":"TSMGO35M","index":34,"n_rows":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","회원정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO35M","Target Table","td_TSMGO35M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"sale_sco","int ","sale_sco","int "]
[null,"delivery_gap","int ","delivery_gap","int "]
[null,"sear_goods_nm","varchar(200) ","sear_goods_nm","varchar(200) "]
[null,"goods_stat_gb","int ","goods_stat_gb","int "]
[null,"goods_cont","int ","goods_cont","int "]
[null,"review_cnt","int ","review_cnt","int "]
[null,"auth_info","varchar(255) ","auth_info","varchar(255) "]
[null,"cnt_sum","int ","cnt_sum","int "]
[null,"day_1st","int ","day_1st","int "]
[null,"day_2nd","int ","day_2nd","int "]
[null,"day_3rd","int ","day_3rd","int "]
[null,"day_4th","int ","day_4th","int "]
[null,"day_5th","int ","day_5th","int "]
[null,"day_6th","int ","day_6th","int "]
[null,"day_7th","int ","day_7th","int "]
[null,"week_1st","int ","week_1st","int "]
[null,"week_2nd","int ","week_2nd","int "]
[null,"week_3rd","int ","week_3rd","int "]
[null,"week_4th","int ","week_4th","int "]
[null,"seq","int ","seq","int "]
[null,"month_2nd","int ","month_2nd","int "]
[null,"month_3rd","int ","month_3rd","int "]
[null,"week_1st_ord_cnt","int ","week_1st_ord_cnt","int "]
[null,"pur_sco","int ","pur_sco","int "]
[null,"pur_sco_week_1st","int ","pur_sco_week_1st","int "]
[null,"pur_sco_week_2nd","int ","pur_sco_week_2nd","int "]
[null,"pur_sco_week_3rd","int ","pur_sco_week_3rd","int "]
[null,"pur_sco_week_4th","int ","pur_sco_week_4th","int "]
[null,"available_cnt","int ","available_cnt","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_gb","char(1) ","upt_gb","char(1) "]
[null,"paju_sale_sco","int ","paju_sale_sco","int "]
[null,"paju_delivery_gap","int ","paju_delivery_gap","int "]
[null,"paju_cnt_sum","int ","paju_cnt_sum","int "]
[null,"paju_day_1st","int ","paju_day_1st","int "]
[null,"paju_day_2nd","int ","paju_day_2nd","int "]
[null,"paju_day_3rd","int ","paju_day_3rd","int "]
[null,"paju_day_4th","int ","paju_day_4th","int "]
[null,"paju_day_5th","int ","paju_day_5th","int "]
[null,"paju_day_6th","int ","paju_day_6th","int "]
[null,"paju_day_7th","int ","paju_day_7th","int "]
[null,"paju_week_1st","int ","paju_week_1st","int "]
[null,"paju_week_2nd","int ","paju_week_2nd","int "]
[null,"paju_week_3rd","int ","paju_week_3rd","int "]
[null,"paju_week_4th","int ","paju_week_4th","int "]
[null,"paju_seq","int ","paju_seq","int "]
[null,"paju_month_2nd","int ","paju_month_2nd","int "]
[null,"paju_month_3rd","int ","paju_month_3rd","int "]
[null,"paju_week_1st_ord_cnt","int ","paju_week_1st_ord_cnt","int "]
[null,"paju_pur_sco","int ","paju_pur_sco","int "]
[null,"paju_pur_sco_week_1st","int ","paju_pur_sco_week_1st","int "]
[null,"paju_pur_sco_week_2nd","int ","paju_pur_sco_week_2nd","int "]
[null,"paju_pur_sco_week_3rd","int ","paju_pur_sco_week_3rd","int "]
[null,"paju_pur_sco_week_4th","int ","paju_pur_sco_week_4th","int "]
[null,"paju_available_cnt","int ","paju_available_cnt","int "]
[null,"paju_reg_dts","datetime ","paju_reg_dts","datetime(3) "]
[null,"youngnam_sale_sco","int ","youngnam_sale_sco","int "]
[null,"youngnam_delivery_gap","int ","youngnam_delivery_gap","int "]
[null,"youngnam_cnt_sum","int ","youngnam_cnt_sum","int "]
[null,"youngnam_day_1st","int ","youngnam_day_1st","int "]
[null,"youngnam_day_2nd","int ","youngnam_day_2nd","int "]
[null,"youngnam_day_3rd","int ","youngnam_day_3rd","int "]
[null,"youngnam_day_4th","int ","youngnam_day_4th","int "]
[null,"youngnam_day_5th","int ","youngnam_day_5th","int "]
[null,"youngnam_day_6th","int ","youngnam_day_6th","int "]
[null,"youngnam_day_7th","int ","youngnam_day_7th","int "]
[null,"youngnam_week_1st","int ","youngnam_week_1st","int "]
[null,"youngnam_week_2nd","int ","youngnam_week_2nd","int "]
[null,"youngnam_week_3rd","int ","youngnam_week_3rd","int "]
[null,"youngnam_week_4th","int ","youngnam_week_4th","int "]
[null,"youngnam_seq","int ","youngnam_seq","int "]
[null,"youngnam_month_2nd","int ","youngnam_month_2nd","int "]
[null,"youngnam_month_3rd","int ","youngnam_month_3rd","int "]
[null,"youngnam_week_1st_ord_cnt","int ","youngnam_week_1st_ord_cnt","int "]
[null,"youngnam_pur_sco","int ","youngnam_pur_sco","int "]
[null,"youngnam_pur_sco_week_1st","int ","youngnam_pur_sco_week_1st","int "]
[null,"youngnam_pur_sco_week_2nd","int ","youngnam_pur_sco_week_2nd","int "]
[null,"youngnam_pur_sco_week_3rd","int ","youngnam_pur_sco_week_3rd","int "]
[null,"youngnam_pur_sco_week_4th","int ","youngnam_pur_sco_week_4th","int "]
[null,"youngnam_available_cnt","int ","youngnam_available_cnt","int "]
[null,"youngnam_reg_dts","datetime ","youngnam_reg_dts","datetime(3) "]
[null,"week_2nd_ord_cnt","int ","week_2nd_ord_cnt","int "]
[null,"week_3rd_ord_cnt","int ","week_3rd_ord_cnt","int "]
[null,"week_4th_ord_cnt","int ","week_4th_ord_cnt","int "]
[null,"paju_week_2nd_ord_cnt","int ","paju_week_2nd_ord_cnt","int "]
[null,"paju_week_3rd_ord_cnt","int ","paju_week_3rd_ord_cnt","int "]
[null,"paju_week_4th_ord_cnt","int ","paju_week_4th_ord_cnt","int "]
[null,"youngnam_week_2nd_ord_cnt","int ","youngnam_week_2nd_ord_cnt","int "]
[null,"youngnam_week_3rd_ord_cnt","int ","youngnam_week_3rd_ord_cnt","int "]
[null,"youngnam_week_4th_ord_cnt","int ","youngnam_week_4th_ord_cnt","int "]

{"sheet":"TSMGO40S","index":35,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품별평점요약.리뷰"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO40S","Target Table","TD_TSMGO40S"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"gcount","int ","gcount","int "]
[null,"cont","int ","cont","int "]
[null,"stat","int ","stat","int "]

{"sheet":"TSMGO82R","index":36,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","상품이러닝이북연결정보"]
[null,"Source Database","Drone","Target Database","story24"]
[null,"Sourse Table","TSMGO82R","Target Table","TD_TSMGO82R"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"goods_no","int ","goods_no","int "]
[null,"ebook_goods_no","int ","ebook_goods_no","int "]
[null,"elearning_goods_no","int ","elearning_goods_no","int "]
[null,"opt_goods_no","int ","opt_goods_no","int "]

{"sheet":"TSMME01M","index":37,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","회원정보"]
[null,"Source Database","SCV","Target Database","story24"]
[null,"Sourse Table","TSMME01M","Target Table","TD_TSMME01M"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"mem_no","int ","mem_no","int "]
[null,"mem_nm","varchar(50) ","mem_nm","varchar(50) "]
[null,"mem_id","varchar(80) ","mem_id","varchar(80) "]
[null,"sex","char(1) ","sex","char(1) "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"nick_nm","varchar(50) ","nick_nm","varchar(50) "]
[null,"rnm_chk_dts","datetime ","rnm_chk_dts","datetime(3) "]

{"sheet":"GL_ART","index":38,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","채널예스아티클"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_ART","Target Table","TG_GL_ART"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"art_no","int ","art_no","int "]
[null,"art_no_pre","int ","art_no_pre","int "]
[null,"cate_no","int ","cate_no","int "]
[null,"cd_no","int ","cd_no","int "]
[null,"tag_id","int ","tag_id","int "]
[null,"cnt_no","int ","cnt_no","int "]
[null,"ttl","nvarchar(510) ","ttl","nvarchar(510) "]
[null,"sub_ttl","nvarchar(510) ","sub_ttl","nvarchar(510) "]
[null,"vw_cnt","int ","vw_cnt","int "]
[null,"thnal","varchar(255) ","thnal","varchar(255) "]
[null,"intr","nvarchar(1000) ","intr","nvarchar(1000) "]
[null,"cont","text(16) ","cont","mediumtext"]
[null,"age_lmt_yn","char(1) ","age_lmt_yn","char(1) "]
[null,"sbd_no","int ","sbd_no","int "]
[null,"pub_yn","char(1) ","pub_yn","char(1) "]
[null,"appr_yn","char(1) ","appr_yn","char(1) "]
[null,"wrt_no","int ","wrt_no","int "]
[null,"ttl_sort_no","varchar(6) ","ttl_sort_no","varchar(6) "]
[null,"med_no","int ","med_no","int "]
[null,"goods_no","int ","goods_no","int "]
[null,"ttl_mng_nm","varchar(100) ","ttl_mng_nm","varchar(100) "]
[null,"ttl_mng_prfl","text(16) ","ttl_mng_prfl","mediumtext"]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]
[null,"item_id","int ","item_id","int "]
[null,"main_disp_yn","char(1) ","main_disp_yn","char(1) "]

{"sheet":"GL_CATE","index":39,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","채널예스카테고리"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_CATE","Target Table","TG_GL_CATE"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"cate_no","int ","cate_no","int "]
[null,"cate_no_pre","varchar(50) ","cate_no_pre","varchar(50) "]
[null,"alt_URL","varchar(255) ","alt_URL","varchar(255) "]
[null,"pat_no","int ","pat_no","int "]
[null,"tree","varchar(255) ","tree","varchar(255) "]
[null,"sort","int ","sort","int "]
[null,"dpth","int ","dpth","int "]
[null,"ttl","nvarchar(510) ","ttl","nvarchar(510) "]
[null,"ttl_html","nvarchar(510) ","ttl_html","nvarchar(510) "]
[null,"cate_cd_no","int ","cate_cd_no","int "]
[null,"art_gb_tpl_case_page_no","int ","art_gb_tpl_case_page_no","int "]
[null,"lst_gb_tpl_case_page_no","int ","lst_gb_tpl_case_page_no","int "]
[null,"list_img","varchar(100) ","list_img","varchar(100) "]
[null,"list_img_path","varchar(100) ","list_img_path","varchar(100) "]
[null,"cont_URL","varchar(100) ","cont_URL","varchar(100) "]
[null,"sdb_gb_tpl_case_page_no","int ","sdb_gb_tpl_case_page_no","int "]
[null,"sub_cate_yn","char(1) ","sub_cate_yn","char(1) "]
[null,"end_yn","char(1) ","end_yn","char(1) "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_mng_no","int ","reg_mng_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_mng_no","int ","upt_mng_no","int "]

{"sheet":"GL_CD","index":40,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","채널예스공통코드"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_CD","Target Table","TG_GL_CD"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"cd_no","int ","cd_no","int "]
[null,"gb","varchar(20) ","gb","varchar(20) "]
[null,"nm","varchar(50) ","nm","varchar(50) "]
[null,"value","varchar(50) ","value","varchar(50) "]
[null,"pat_no","int ","pat_no","int "]
[null,"dpth","int ","dpth","int "]
[null,"sub_cate_yn","char(1) ","sub_cate_yn","char(1) "]
[null,"sort","int ","sort","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]

{"sheet":"GL_CH_YES_WEBZINE_DOWN","index":41,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","웹진"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_CH_YES_WEBZINE_DOWN","Target Table","TG_GL_CH_YES_WEBZINE_DOWN"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"seq","int ","seq","int "]
[null,"year","int ","year","int "]
[null,"month","int ","month","int "]
[null,"cover_story","varchar(1000) ","cover_story","varchar(1000) "]
[null,"intro","ntext(16) ","intro","text"]
[null,"cover_image_items_no","int ","cover_image_items_no","int "]
[null,"down_path_items_no","int ","down_path_items_no","int "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"goods_no","int ","goods_no","int "]

{"sheet":"TG_GL_EXPS_INFO","index":42,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","채널확장정보"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_EXPS_INFO","Target Table","TG_GL_EXPS_INFO"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"exps_info_no","int ","exps_info_no","int "]
[null,"cd_no","int ","cd_no","int "]
[null,"gb","varchar(50) ","gb","varchar(50) "]
[null,"cont_gb_no","int ","cont_gb_no","int "]
[null,"rfrc_gb_no","int ","rfrc_gb_no","int "]
[null,"rfrc_no","int ","rfrc_no","int "]
[null,"origin_value","varchar(255) ","origin_value","varchar(255) "]
[null,"origin_no","int ","origin_no","int "]
[null,"cont","nvarchar(2000) ","cont","varchar(2000) "]
[null,"sort","int ","sort","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]

{"sheet":"GL_GALY","index":43,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","갤러리"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_GALY","Target Table","TG_GL_GALY"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"galy_no","int ","galy_no","int "]
[null,"galy_no_pre","int ","galy_no_pre","int "]
[null,"cd_no","int ","cd_no","int "]
[null,"ttl","nvarchar(510) ","ttl","varchar(510) "]
[null,"gb","varchar(10) ","gb","varchar(10) "]
[null,"cont","text(16) ","cont","mediumtext"]
[null,"rfrc_gb_no","int ","rfrc_gb_no","int "]
[null,"cont_gb_no","int ","cont_gb_no","int "]
[null,"img","varchar(255) ","img","varchar(255) "]
[null,"med_key","varchar(255) ","med_key","varchar(255) "]
[null,"vw_cnt","int ","vw_cnt","int "]
[null,"disp_yn","char(1) ","disp_yn","char(1) "]
[null,"disp_main_yn","char(1) ","disp_main_yn","char(1) "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]
[null,"all_disp_yn","char(1) ","all_disp_yn","char(1) "]

{"sheet":"GL_ITems","index":44,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","기사 아이템"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_Items","Target Table","TG_GL_Items"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"items_no","int ","items_no","int "]
[null,"ttl","nvarchar(510) ","ttl","varchar(510)"]
[null,"file_path","varchar(50) ","file_path","varchar(50)"]
[null,"file_nm","nvarchar(510) ","file_nm","varchar(510)"]
[null,"enc_file_nm","varchar(50) ","enc_file_nm","varchar(50)"]
[null,"cont_gb_no","int ","cont_gb_no","int "]
[null,"rfrc_gb_no","int ","rfrc_gb_no","int "]
[null,"rfrc_no","int ","rfrc_no","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]

{"sheet":"GL_LIBY","index":45,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","명사의 서재"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_LIBY","Target Table","TG_GL_LIBY"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"liby_no","int ","liby_no","int "]
[null,"cd_no","int ","cd_no","int "]
[null,"ttl","nvarchar(510) ","ttl","varchar(510)"]
[null,"ctr","nvarchar(510) ","ctr","varchar(510)"]
[null,"items_no","int ","items_no","int"]
[null,"main_img","varchar(255) ","main_img","varchar(255)"]
[null,"middle_img","varchar(255) ","middle_img","varchar(255)"]
[null,"small_img","varchar(255) ","small_img","varchar(255)"]
[null,"sbd_img","varchar(255) ","sbd_img","varchar(255)"]
[null,"med_no","int ","med_no","int"]
[null,"URL","varchar(255) ","URL","varchar(255)"]
[null,"cont_ttl","nvarchar(100) ","cont_ttl","varchar(100)"]
[null,"cont_nm","nvarchar(100) ","cont_nm","varchar(100)"]
[null,"cont_ctr","nvarchar(510) ","cont_ctr","varchar(510)"]
[null,"cont_intr","nvarchar(510) ","cont_intr","varchar(510)"]
[null,"cont_cont","MEDIUMTEXT","cont_cont","mediumtext"]
[null,"disp_yn","char(1) ","disp_yn","char(1) "]
[null,"disp_main_yn","char(1) ","disp_main_yn","char(1) "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"vw_cnt","int ","vw_cnt","int "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]

{"sheet":"GL_RFRC_GB","index":46,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","RFRC 구분관리"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_RFRC_GB","Target Table","TG_GL_RFRC_GB"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"rfrc_gb_no","int","rfrc_gb_no","int"]
[null,"ttl_sort_no__mg","varchar(6)","ttl_sort_no__mg","varchar(6)"]
[null,"ttl","nvarchar(255)","ttl","varchar(510)"]
[null,"ctr","nvarchar(255)","ctr","varchar(510)"]
[null,"sort","int","sort","int"]
[null,"del_yn","char(1)","del_yn","char(1)"]
[null,"reg_dts","datetime","reg_dts","datetime(3)"]
[null,"reg_wrt_no","int","reg_wrt_no","int"]
[null,"upt_dts","datetime","upt_dts","datetime(3)"]
[null,"upt_wrt_no","int","upt_wrt_no","int"]

{"sheet":"GL_TAG","index":47,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","채널 테그"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_TAG","Target Table","TG_GL_TAG"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"tag_no","int ","tag_no","int "]
[null,"ttl","nvarchar(510) ","ttl","varchar(510)"]
[null,"cd_no","int ","cd_no","int "]
[null,"cont_gb_no","int ","cont_gb_no","int "]
[null,"rfrc_gb_no","int ","rfrc_gb_no","int "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]

{"sheet":"GL_TAG_LINK","index":48,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","채널테그연결"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_TAG_LINK","Target Table","TG_GL_TAG_LINK"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"tag_link_no","int ","tag_link_no","int "]
[null,"cd_no","int ","cd_no","int "]
[null,"tag_no","int ","tag_no","int "]
[null,"cont_gb_no","int ","cont_gb_no","int "]
[null,"rfrc_gb_no","int ","rfrc_gb_no","int "]
[null,"rfrc_no","int ","rfrc_no","int "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]

{"sheet":"GL_VW_YMD_SUM","index":49,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","조회수통계"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_VW_YMD_SUM","Target Table","TG_GL_VW_YMD_SUM"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"vw_ymd","date ","vw_ymd","date "]
[null,"vw_gb","int ","vw_gb","int "]
[null,"cont_no","int ","cont_no","int "]
[null,"vw_cnt","int ","vw_cnt","int "]

{"sheet":"GL_CLTE_EVE","index":50,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","문화행사"]
[null,"Source Database","예스채널(Goliath)","Target Database","story24"]
[null,"Sourse Table","GL_CLTE_EVE","Target Table","TG_GL_CLTE_EVE"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"clte_eve_no","int ","clte_eve_no","int "]
[null,"sect_nm","nvarchar(510) ","sect_nm","varchar(510) "]
[null,"ttl","nvarchar(510) ","ttl","varchar(510) "]
[null,"cd_no","int ","cd_no","int "]
[null,"inv_date","datetime ","inv_date","datetime(3) "]
[null,"eve_addr","nvarchar(510) ","eve_addr","varchar(510) "]
[null,"strt_dts","datetime ","strt_dts","datetime(3) "]
[null,"end_dts","datetime ","end_dts","datetime(3) "]
[null,"inv_rslt_date","datetime ","inv_rslt_date","datetime(3) "]
[null,"inv_cnt","int ","inv_cnt","int "]
[null,"inv_rslt","nvarchar(510) ","inv_rslt","varchar(510) "]
[null,"items_no","int ","items_no","int "]
[null,"sort","int ","sort","int "]
[null,"url","varchar(255) ","url","varchar(255) "]
[null,"cont","ntext(16) ","cont","mediumtext"]
[null,"thnal","varchar(255) ","thnal","varchar(255) "]
[null,"disp_yn","char(1) ","disp_yn","char(1) "]
[null,"disp_main_yn","char(1) ","disp_main_yn","char(1) "]
[null,"del_yn","char(1) ","del_yn","char(1) "]
[null,"reg_dts","datetime ","reg_dts","datetime(3) "]
[null,"reg_wrt_no","int ","reg_wrt_no","int "]
[null,"upt_dts","datetime ","upt_dts","datetime(3) "]
[null,"upt_wrt_no","int ","upt_wrt_no","int "]
[null,"mobile_url","varchar(255) ","mobile_url","varchar(255) "]
[null,"mobile_link","varchar(500) ","mobile_link","varchar(500) "]

{"sheet":"IST24_CONTENT_INFO_T","index":51,"n_rows":116,"n_cols":6,"rows_kept":116,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스냅콘텐츠"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_CONTENT_INFO_T","Target Table","TI_IST24_CONTENT_INFO_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"idx","int ","idx","int "]
[null,"writer","nvarchar(40) ","writer","varchar(40) "]
[null,"auth","nchar(2) ","auth","char(2) "]
[null,"position1","int ","position1","int "]
[null,"position2","int ","position2","int "]
[null,"subject","nvarchar(510) ","subject","varchar(510) "]
[null,"content","nvarchar(max) ","content","mediumtext"]
[null,"tagname1","nvarchar(200) ","tagname1","varchar(200) "]
[null,"storeURL1","nvarchar(400) ","storeURL1","varchar(400) "]
[null,"storeURL2","nvarchar(400) ","storeURL2","varchar(400) "]
[null,"storeURL3","nvarchar(400) ","storeURL3","varchar(400) "]
[null,"storeURL4","nvarchar(400) ","storeURL4","varchar(400) "]
[null,"linkURL1","nvarchar(400) ","linkURL1","varchar(400) "]
[null,"linkURL2","nvarchar(400) ","linkURL2","varchar(400) "]
[null,"linkURL3","nvarchar(400) ","linkURL3","varchar(400) "]
[null,"accesswriter","nvarchar(200) ","accesswriter","text"]
[null,"accessyn","nchar(2) ","accessyn","char(2) "]
[null,"openyn","nchar(2) ","openyn","char(2) "]
[null,"regdate","datetime ","regdate","datetime(3) "]
[null,"accessdate","datetime ","accessdate","datetime(3) "]
[null,"origin","nvarchar(max) ","origin","mediumtext"]
[null,"hit","int ","hit","int "]
[null,"reply","int ","reply","int "]
[null,"writerid","nvarchar(40) ","writerid","varchar(40) "]
[null,"accessid","nvarchar(40) ","accessid","varchar(40) "]
[null,"storeoldimg1","nvarchar(200) ","storeoldimg1","text"]
[null,"storenewimg1","nvarchar(200) ","storenewimg1","text"]
[null,"storeoldimg2","nvarchar(200) ","storeoldimg2","text"]
[null,"storenewimg2","nvarchar(200) ","storenewimg2","text"]
[null,"storeoldimg3","nvarchar(200) ","storeoldimg3","text"]
[null,"storenewimg3","nvarchar(200) ","storenewimg3","text"]
[null,"storeoldimg4","nvarchar(200) ","storeoldimg4","text"]
[null,"storenewimg4","nvarchar(200) ","storenewimg4","text"]
[null,"tagname2","nvarchar(400) ","tagname2","varchar(400) "]
[null,"tagname3","nvarchar(400) ","tagname3","varchar(400) "]
[null,"tagname4","nvarchar(400) ","tagname4","varchar(400) "]
[null,"tagname5","nvarchar(400) ","tagname5","varchar(400) "]
[null,"contentoldimg","nvarchar(200) ","contentoldimg","text"]
[null,"contentnewimg","nvarchar(200) ","contentnewimg","text"]
[null,"frsumimg","nvarchar(200) ","frsumimg","text"]
[null,"listsumimg","nvarchar(200) ","listsumimg","text"]
[null,"brandstoryimg","nvarchar(200) ","brandstoryimg","text"]
[null,"editcolumnimg","nvarchar(200) ","editcolumnimg","text"]
[null,"viewsumimg","nvarchar(200) ","viewsumimg","text"]
[null,"recom_cnt","bigint ","recom_cnt","bigint "]
[null,"copyright","nchar(2) ","copyright","char(2) "]
[null,"fsbigimg","nvarchar(200) ","fsbigimg","text"]
[null,"fssmallimg","nvarchar(200) ","fssmallimg","text"]
[null,"storeURL5","nvarchar(400) ","storeURL5","varchar(400) "]
[null,"storeURL6","nvarchar(400) ","storeURL6","varchar(400) "]
[null,"storeURL7","nvarchar(400) ","storeURL7","varchar(400) "]
[null,"storeURL8","nvarchar(400) ","storeURL8","varchar(400) "]
[null,"storeURL9","nvarchar(400) ","storeURL9","varchar(400) "]
[null,"storeURL10","nvarchar(400) ","storeURL10","varchar(400) "]
[null,"storeoldimg5","nvarchar(200) ","storeoldimg5","text"]
[null,"storenewimg5","nvarchar(200) ","storenewimg5","text"]
[null,"storeoldimg6","nvarchar(200) ","storeoldimg6","text"]
[null,"storenewimg6","nvarchar(200) ","storenewimg6","text"]
[null,"storeoldimg7","nvarchar(200) ","storeoldimg7","text"]
[null,"storenewimg7","nvarchar(200) ","storenewimg7","text"]
[null,"storeoldimg8","nvarchar(200) ","storeoldimg8","text"]
[null,"storenewimg8","nvarchar(200) ","storenewimg8","text"]
[null,"storeoldimg9","nvarchar(200) ","storeoldimg9","text"]
[null,"storenewimg9","nvarchar(200) ","storenewimg9","text"]
[null,"storeoldimg10","nvarchar(200) ","storeoldimg10","text"]
[null,"storenewimg10","nvarchar(200) ","storenewimg10","text"]
[null,"origintype","nchar(2) ","origintype","char(2) "]
[null,"originoldimg","nvarchar(200) ","originoldimg","text"]
[null,"originnewimg","nvarchar(200) ","originnewimg","text"]
[null,"replyyn","nchar(2) ","replyyn","char(2) "]
[null,"pollyn","nchar(2) ","pollyn","char(2) "]
[null,"pollcnt","nchar(2) ","pollcnt","char(2) "]
[null,"pollnm1","nvarchar(20) ","pollnm1","varchar(20) "]
[null,"pollnm2","nvarchar(20) ","pollnm2","varchar(20) "]
[null,"pollnm3","nvarchar(20) ","pollnm3","varchar(20) "]
[null,"pollnm4","nvarchar(20) ","pollnm4","varchar(20) "]
[null,"pollnm5","nvarchar(20) ","pollnm5","varchar(20) "]
[null,"linkoldimg1","nvarchar(200) ","linkoldimg1","text"]
[null,"linkoldimg2","nvarchar(200) ","linkoldimg2","text"]
[null,"linkoldimg3","nvarchar(200) ","linkoldimg3","text"]
[null,"linknewimg1","nvarchar(200) ","linknewimg1","text"]
[null,"linknewimg2","nvarchar(200) ","linknewimg2","text"]
[null,"linknewimg3","nvarchar(200) ","linknewimg3","text"]
[null,"streetcontry","nvarchar(20) ","streetcontry","varchar(20) "]
[null,"eventnum","int ","eventnum","int "]
[null,"nid","int ","nid","int "]
[null,"linksubject1","nvarchar(100) ","linksubject1","varchar(100) "]
[null,"linksubject2","nvarchar(100) ","linksubject2","varchar(100) "]
[null,"linksubject3","nvarchar(100) ","linksubject3","varchar(100) "]
[null,"link1position1","int ","link1position1","int "]
[null,"link2position1","int ","link2position1","int "]
[null,"link3position1","int ","link3position1","int "]
[null,"link1position2","int ","link1position2","int "]
[null,"link2position2","int ","link2position2","int "]
[null,"link3position2","int ","link3position2","int "]
[null,"shortmemo","nvarchar(2000) ","shortmemo","varchar(2000) "]
[null,"storesubject1","nvarchar(200) ","storesubject1","text"]
[null,"storesubject2","nvarchar(200) ","storesubject2","text"]
[null,"storesubject3","nvarchar(200) ","storesubject3","text"]
[null,"storesubject4","nvarchar(200) ","storesubject4","text"]
[null,"storesubject5","nvarchar(200) ","storesubject5","text"]
[null,"storesubject6","nvarchar(200) ","storesubject6","text"]
[null,"storesubject7","nvarchar(200) ","storesubject7","text"]
[null,"storesubject8","nvarchar(200) ","storesubject8","text"]
[null,"storesubject9","nvarchar(200) ","storesubject9","text"]
[null,"storesubject10","nvarchar(200) ","storesubject10","text"]
[null,"replydate","datetime ","replydate","datetime(3) "]
[null,"nateca","nvarchar(20) ","nateca","varchar(20) "]
[null,"natesh","nvarchar(200) ","natesh","text"]

{"sheet":"IST24_CONTENT_LIST_INFO_T","index":52,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스냅콘텐츠목록"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_CONTENT_LIST_INFO_T","Target Table","TI_IST24_CONTENT_LIST_INFO_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"idx","int ","idx","int "]
[null,"subject","nvarchar(510) ","subject","varchar(510) "]
[null,"position1","int ","position1","int "]
[null,"position2","int ","position2","int "]
[null,"openyn","nchar(2) ","openyn","char(2) "]
[null,"shortmemo","nvarchar(4000) ","shortmemo","varchar(4000) "]
[null,"hit","int ","hit","int "]
[null,"reply","int ","reply","int "]
[null,"recom_cnt","int ","recom_cnt","int "]
[null,"chardate","nchar(20) ","chardate","char(20) "]
[null,"accessyn","nchar(2) ","accessyn","char(2) "]
[null,"listsumimg","nvarchar(200) ","listsumimg","varchar(200) "]
[null,"replydate","datetime ","replydate","datetime(3) "]
[null,"regi_date","datetime ","regi_date","datetime(3) "]
[null,"streetcontry","nvarchar(20) ","streetcontry","varchar(20) "]
[null,"contentnewimg","nvarchar(200) ","contentnewimg","varchar(200) "]

{"sheet":"IST24_GROUP_CONTENT_INFO_T","index":53,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","콘텐츠 그룹"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_GROUP_CONTENT_INFO_T","Target Table","TI_IST24_GROUP_CONTENT_INFO_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"groupidx","int ","groupidx","int "]
[null,"subject","nvarchar(510) ","subject","varchar(510) "]
[null,"shortsubject","nvarchar(240) ","shortsubject","varchar(240) "]
[null,"shortmemo","nvarchar(1000) ","shortmemo","varchar(1000) "]
[null,"position1","int ","position1","int "]
[null,"position2","int ","position2","int "]
[null,"openyn","char(1) ","openyn","char(1) "]
[null,"accessyn","char(1) ","accessyn","char(1) "]
[null,"maincontentidx","int ","maincontentidx","int "]
[null,"tagname","nvarchar(2008) ","tagname","varchar(2008) "]
[null,"useyn","char(1) ","useyn","char(1) "]
[null,"writerid","nvarchar(40) ","writerid","varchar(40) "]
[null,"regdate","datetime ","regdate","datetime(3) "]
[null,"modifierid","nvarchar(40) ","modifierid","varchar(40) "]
[null,"moddate","datetime ","moddate","datetime(3) "]
[null,"accessid","nvarchar(40) ","accessid","varchar(40) "]
[null,"accessdate","datetime ","accessdate","datetime(3) "]

{"sheet":"IST24_GROUP_CONTENT_MAPPING_T","index":54,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","콘텐츠 그룹 매핑"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_GROUP_CONTENT_MAPPING_T","Target Table","TI_IST24_GROUP_CONTENT_MAPPING_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"groupidx","int ","groupidx","int "]
[null,"idx","int ","idx","int "]
[null,"useyn","char(1) ","useyn","char(1) "]
[null,"moddate","datetime ","moddate","datetime(3) "]

{"sheet":"IST24_MAIN_CONTENT_INFO_T","index":55,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스냅메인콘텐츠"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_MAIN_CONTENT_INFO_T","Target Table","TI_IST24_MAIN_CONTENT_INFO_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"idx","int ","idx","int "]
[null,"kind","nchar(2) ","kind","char(2) "]
[null,"subject","nvarchar(510) ","subject","varchar(510) "]
[null,"writer","nvarchar(60) ","writer","varchar(60) "]
[null,"linkyn","nchar(2) ","linkyn","char(2) "]
[null,"linkURL","nvarchar(400) ","linkURL","varchar(400) "]
[null,"content","nvarchar(max) ","content","text"]
[null,"oldfilename","nvarchar(100) ","oldfilename","varchar(100) "]
[null,"newfilename","nvarchar(100) ","newfilename","varchar(100) "]
[null,"keyword","nvarchar(400) ","keyword","varchar(400) "]
[null,"regdate","datetime ","regdate","datetime(3) "]
[null,"stime","nvarchar(20) ","stime","varchar(20) "]
[null,"etime","nvarchar(20) ","etime","varchar(20) "]
[null,"sdate","nvarchar(20) ","sdate","varchar(20) "]
[null,"edate","nvarchar(20) ","edate","varchar(20) "]
[null,"boardidx","int ","boardidx","int "]

{"sheet":"IST24_TAG_INFO_T","index":56,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스냅메뉴정보"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_TAG_INFO_T","Target Table","TI_IST24_TAG_INFO_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"idx","int ","idx","int "]
[null,"position1","int ","position1","int "]
[null,"position2","int ","position2","int "]
[null,"tagname","nvarchar(6000) ","tagname","varchar(6000) "]
[null,"hitcnt","bigint ","hitcnt","bigint "]
[null,"admincnt","nvarchar(20) ","admincnt","varchar(20) "]
[null,"regdate","datetime ","regdate","datetime(3) "]
[null,"writer","nvarchar(40) ","writer","varchar(40) "]
[null,"connect_idx","int ","connect_idx","int "]
[null,"sort","int ","sort","int "]
[null,"gubun","nvarchar(20) ","gubun","varchar(20) "]
[null,"hittagyn","nchar(2) ","hittagyn","char(2) "]
[null,"maintagyn","nchar(2) ","maintagyn","char(2) "]

{"sheet":"IST24_USER_MENU_INFO","index":57,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스냅메뉴정보"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_USER_MENU_INFO","Target Table","TI_IST24_USER_MENU_INFO"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"menuseq","int ","menuseq","int "]
[null,"step1","int ","step1","int "]
[null,"step2","int ","step2","int "]
[null,"step3","int ","step3","int "]
[null,"step4","int ","step4","int "]
[null,"menunm","nvarchar(400) ","menunm","varchar(400) "]
[null,"menuURL","nvarchar(800) ","menuURL","varchar(800) "]
[null,"linkyn","nchar(2) ","linkyn","char(2) "]
[null,"insdate","datetime ","insdate","datetime(3) "]
[null,"insmemno","nvarchar(32) ","insmemno","varchar(32) "]
[null,"moddate","datetime ","moddate","datetime(3) "]
[null,"modmemno","nvarchar(32) ","modmemno","varchar(32) "]
[null,"sort","int ","sort","int "]
[null,"writer","nvarchar(40) ","writer","varchar(40) "]
[null,"snsyn","nchar(2) ","snsyn","char(2) "]
[null,"menucnt","int ","menucnt","int "]
[null,"gnbonoldimg","nvarchar(200) ","gnbonoldimg","varchar(200) "]
[null,"gnbonnewimg","nvarchar(200) ","gnbonnewimg","varchar(200) "]
[null,"gnboffoldimg","nvarchar(200) ","gnboffoldimg","varchar(200) "]
[null,"gnboffnewimg","nvarchar(200) ","gnboffnewimg","varchar(200) "]
[null,"lnboldimg","nvarchar(200) ","lnboldimg","varchar(200) "]
[null,"lnbnewimg","nvarchar(200) ","lnbnewimg","varchar(200) "]
[null,"rnbonoldimg","nvarchar(200) ","rnbonoldimg","varchar(200) "]
[null,"rnbonnewimg","nvarchar(200) ","rnbonnewimg","varchar(200) "]
[null,"rnboffoldimg","nvarchar(200) ","rnboffoldimg","varchar(200) "]
[null,"rnboffnewimg","nvarchar(200) ","rnboffnewimg","varchar(200) "]

{"sheet":"IST24_WRITER_INFO_T","index":58,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스냅작가정보"]
[null,"Source Database","스냅 (iStyle24)","Target Database","story24"]
[null,"Sourse Table","IST24_WRITER_INFO_T","Target Table","TI_IST24_WRITER_INFO_T"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"idx","int ","idx","int "]
[null,"loginid","nvarchar(40) ","loginid","varchar(40) "]
[null,"password","nvarchar(40) ","password","varchar(40) "]
[null,"loginnm","nvarchar(40) ","loginnm","varchar(40) "]
[null,"hpnm","nvarchar(40) ","hpnm","varchar(40) "]
[null,"emailid","nvarchar(100) ","emailid","varchar(100) "]
[null,"etcinfo","nvarchar(400) ","etcinfo","varchar(400) "]
[null,"reg_date","smalldatetime ","reg_date","datetime"]
[null,"oldfilename","nvarchar(100) ","oldfilename","varchar(100) "]
[null,"newfilename","nvarchar(100) ","newfilename","varchar(100) "]
[null,"lastlogin","smalldatetime ","lastlogin","datetime"]
[null,"position1","int ","position1","int "]
[null,"position2","int ","position2","int "]
[null,"editcolumnimg","nvarchar(200) ","editcolumnimg","varchar(200) "]
[null,"mainauthorimg","nvarchar(200) ","mainauthorimg","varchar(200) "]
[null,"loginyn","nchar(2) ","loginyn","char(2) "]

{"sheet":"T_Code","index":59,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화공통코드"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","T_Code","Target Table","TV_T_Code"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"code_seq","int ","code_seq","int "]
[null,"code_id","varchar(20) ","code_id","varchar(20) "]
[null,"code_name","varchar(50) ","code_name","varchar(50) "]
[null,"code_category","varchar(50) ","code_category","varchar(50) "]
[null,"code_order","int ","code_order","int "]
[null,"sys_date","datetime ","sys_date","datetime(3)"]

{"sheet":"T_ORDER_DETAIL","index":60,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화구매상세"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","T_ORDER_DETAIL","Target Table","TV_T_ORDER_DETAIL"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"order_detail_id","int ","order_detail_id","int "]
[null,"order_id","int ","order_id","int "]
[null,"movie_id","varchar(20) ","movie_id","varchar(20) "]
[null,"origin_price","bigint ","origin_price","bigint "]
[null,"sale_price","bigint ","sale_price","bigint "]
[null,"down_count","int ","down_count","int "]
[null,"available_download_day","int ","available_download_day","int "]
[null,"available_download_count","int ","available_download_count","int "]
[null,"flag","char(1) ","flag","char(1) "]
[null,"down_date","datetime ","down_date","datetime(3)"]

{"sheet":"T_ORDER_MASTER","index":61,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화구매마스터"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","T_ORDER_MASTER","Target Table","TV_T_ORDER_MASTER"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"order_id","int ","order_id","int "]
[null,"order_seq","nvarchar(100) ","order_seq","varchar(100) "]
[null,"pay_method","varchar(10) ","pay_method","varchar(10) "]
[null,"order_name","varchar(256) ","order_name","varchar(256) "]
[null,"user_id","varchar(20) ","user_id","varchar(20) "]
[null,"user_name","varchar(50) ","user_name","varchar(50) "]
[null,"total_origin_price","bigint ","total_origin_price","bigint "]
[null,"total_amount","bigint ","total_amount","bigint "]
[null,"card_price","bigint ","card_price","bigint "]
[null,"phone_price","bigint ","phone_price","bigint "]
[null,"deposit_price","bigint ","deposit_price","bigint "]
[null,"yes_money","bigint ","yes_money","bigint "]
[null,"yes_product_money","bigint ","yes_product_money","bigint "]
[null,"yes_gift_no","varchar(500) ","yes_gift_no","varchar(500) "]
[null,"coupon_id","numeric(9) ","coupon_id","decimal(9,0)"]
[null,"coupon_price","bigint ","coupon_price","bigint "]
[null,"auth_no","varchar(50) ","auth_no","varchar(50) "]
[null,"order_status","char(4) ","order_status","char(4) "]
[null,"reg_date","datetime ","reg_date","datetime(3) "]
[null,"sale_coupon_id","numeric(9) ","sale_coupon_id","decimal(9,0)"]
[null,"sale_coupon_price","bigint ","sale_coupon_price","bigint "]
[null,"mbaro_seq","bigint ","mbaro_seq","bigint "]
[null,"mbaro_result","varchar(40) ","mbaro_result","varchar(40) "]
[null,"user_sys_info","varchar(200) ","user_sys_info","varchar(200) "]
[null,"happy_money_app_no","varchar(14) ","happy_money_app_no","varchar(14) "]
[null,"happymoney","bigint ","happymoney","bigint "]
[null,"cash_receipt_yn","varchar(1) ","cash_receipt_yn","varchar(1) "]
[null,"cash_receipt_date","datetime ","cash_receipt_date","datetime(3) "]
[null,"o_id_m","varchar(50) ","o_id_m","varchar(50) "]
[null,"order_type","varchar(10) ","order_type","varchar(10) "]
[null,"crema_money","int ","crema_money","int "]
[null,"digital_money","int ","digital_money","int "]
[null,"uid","varchar(50) ","uid","varchar(50) "]

{"sheet":"T_PERSON","index":62,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화인"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","T_PERSON","Target Table","TV_T_PERSON"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"seq_person","int ","seq_person","int "]
[null,"per_id","int ","per_id","int "]
[null,"per_nm","varchar(200) ","per_nm","varchar(200) "]
[null,"dbsts","int ","dbsts","int "]
[null,"birth","varchar(10) ","birth","varchar(10) "]
[null,"per_image","varchar(100) ","per_image","varchar(100) "]
[null,"per_thumb","varchar(100) ","per_thumb","varchar(100) "]
[null,"sys_date","datetime ","sys_date","datetime(3) "]

{"sheet":"TA_CODES","index":63,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화코드"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_CODES","Target Table","TV_TA_CODES"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"cd_id","int ","cd_id","int "]
[null,"grp_cd","varchar(20) ","grp_cd","varchar(20) "]
[null,"grp_nm","varchar(30) ","grp_nm","varchar(30) "]
[null,"cd","varchar(20) ","cd","varchar(20) "]
[null,"cd_nm","varchar(50) ","cd_nm","varchar(50) "]
[null,"add_cd","varchar(20) ","add_cd","varchar(20) "]
[null,"add_nm","varchar(30) ","add_nm","varchar(30) "]
[null,"remark","varchar(7000) ","remark","varchar(7000) "]
[null,"dbsts","int ","dbsts","int "]

{"sheet":"TA_MOVIE_RANK","index":64,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화순위"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_MOVIE_RANK","Target Table","TV_TA_MOVIE_RANK"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"movie_id","varchar(20) ","movie_id","varchar(20) "]
[null,"count_num","int ","count_num","int "]

{"sheet":"TA_PLAY24_STAR_POINT_MST","index":65,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화 평점 테이블"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_PLAY24_STAR_POINT_MST","Target Table","TV_TA_PLAY24_STAR_POINT_MST"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"star_point","float ","star_point","float "]
[null,"tot_star_point","float ","tot_star_point","float "]
[null,"app_cnt","int ","app_cnt","int "]

{"sheet":"TA_VOD_MENU","index":66,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화메뉴"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_MENU","Target Table","TV_TA_VOD_MENU"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"menu_seq","int ","menu_seq","int "]
[null,"menu_nm","varchar(30) ","menu_nm","varchar(30) "]
[null,"highrank_menu","int ","highrank_menu","int "]
[null,"menu_depth","varchar(1) ","menu_depth","varchar(1) "]
[null,"menu_link","varchar(100) ","menu_link","varchar(100) "]
[null,"menu_img_URL","varchar(100) ","menu_img_URL","varchar(100) "]
[null,"display_yn","varchar(1) ","display_yn","varchar(1) "]
[null,"display_sdt","date ","display_sdt","date "]
[null,"display_edt","date ","display_edt","date "]
[null,"menu_priority","int ","menu_priority","int "]
[null,"menu_vod_cnt","int ","menu_vod_cnt","int "]
[null,"main_disp_yn","varchar(1) ","main_disp_yn","varchar(1) "]
[null,"thumb_type","varchar(1) ","thumb_type","varchar(1) "]
[null,"auto_menu_yn","varchar(1) ","auto_menu_yn","varchar(1) "]
[null,"use_yn","varchar(1) ","use_yn","varchar(1) "]
[null,"reg_id","varchar(20) ","reg_id","varchar(20) "]
[null,"reg_dt","datetime ","reg_dt","datetime(3) "]

{"sheet":"TA_VOD_MENU_MAPP","index":67,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","영화메뉴 매핑"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_MENU_MAPP","Target Table","TV_TA_VOD_MENU_MAPP"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"menu_mapp_seq","numeric(9) ","menu_mapp_seq","decimal(9,0)"]
[null,"menu_seq","int ","menu_seq","int "]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"vod_nm","varchar(100) ","vod_nm","varchar(100) "]
[null,"use_yn","varchar(1) ","use_yn","varchar(1) "]
[null,"batch_yn","varchar(1) ","batch_yn","varchar(1) "]
[null,"reg_id","varchar(30) ","reg_id","varchar(30) "]
[null,"reg_dt","datetime ","reg_dt","datetime(3) "]

{"sheet":"TA_VOD_MOBILE","index":68,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스트리밍영화"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_MOBILE","Target Table","TV_TA_VOD_MOBILE"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"grpm_id","varchar(20) ","grpm_id","varchar(20) "]
[null,"vod_id_hash","char(32) ","vod_id_hash","char(32) "]
[null,"vod_nm","varchar(200) ","vod_nm","varchar(200) "]
[null,"org_nm","varchar(200) ","org_nm","varchar(200) "]
[null,"vod_type","varchar(5) ","vod_type","varchar(5) "]
[null,"homepage","varchar(200) ","homepage","varchar(200) "]
[null,"make_y","varchar(4) ","make_y","varchar(4) "]
[null,"vwgrd_cd","varchar(20) ","vwgrd_cd","varchar(20) "]
[null,"open_dt","varchar(10) ","open_dt","varchar(10) "]
[null,"runtime","int ","runtime","int "]
[null,"synopsis","text(16) ","synopsis","mediumtext"]
[null,"genre","varchar(120) ","genre","varchar(120) "]
[null,"genre_cd","varchar(120) ","genre_cd","varchar(120) "]
[null,"characters","varchar(400) ","characters","varchar(400) "]
[null,"directors","varchar(500) ","directors","varchar(500) "]
[null,"priority","int ","priority","int "]
[null,"video_quality","int ","video_quality","int "]
[null,"event_flag","varchar(1) ","event_flag","varchar(1) "]
[null,"event_sdt","varchar(10) ","event_sdt","varchar(10) "]
[null,"event_edt","varchar(10) ","event_edt","varchar(10) "]
[null,"display_yn","varchar(1) ","display_yn","varchar(1) "]
[null,"display_sdt","varchar(10) ","display_sdt","varchar(10) "]
[null,"display_edt","varchar(10) ","display_edt","varchar(10) "]
[null,"original_yn","varchar(1) ","original_yn","varchar(1) "]
[null,"original_word","varchar(100) ","original_word","varchar(100) "]
[null,"theme_yn","varchar(1) ","theme_yn","varchar(1) "]
[null,"adult_keyword_yn","varchar(1) ","adult_keyword_yn","varchar(1) "]
[null,"origin_price","bigint ","origin_price","bigint "]
[null,"sale_price","bigint ","sale_price","bigint "]
[null,"admin_meno","varchar(4000) ","admin_meno","varchar(4000) "]
[null,"use_yn","varchar(1) ","use_yn","varchar(1) "]
[null,"reg_id","varchar(30) ","reg_id","varchar(30) "]
[null,"reg_dt","datetime ","reg_dt","datetime(3) "]
[null,"update_id","varchar(30) ","update_id","varchar(30) "]
[null,"update_dt","datetime ","update_dt","datetime(3) "]
[null,"series_cnt","int ","series_cnt","int "]

{"sheet":"TA_VOD_MOBILE_ENCODE","index":69,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스트리밍영화 인코드"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_MOBILE_ENCODE","Target Table","TV_TA_VOD_MOBILE_ENCODE"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"ENCODE_SEQ","int","ENCODE_SEQ","int"]
[null,"VOD_ID","varchar","VOD_ID","varchar(20)"]
[null,"VOD_NM","varchar","VOD_NM","varchar(200)"]
[null,"VOD_ORIGIN_URL","varchar","VOD_ORIGIN_URL","varchar(100)"]
[null,"VOD_URL","varchar","VOD_URL","varchar(100)"]
[null,"VIDEO_QUALITY","int","VIDEO_QUALITY","int"]
[null,"ENC_STATUS","varchar","ENC_STATUS","varchar(10)"]
[null,"PRIORITY","int","PRIORITY","int"]
[null,"USE_YN","varchar","USE_YN","char(1)"]
[null,"REG_ID","varchar","REG_ID","varchar(30)"]
[null,"REG_DT","datetime","REG_DT","datetime(3)"]

{"sheet":"TA_VOD_MOBILE_GENRE","index":70,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스트리밍영화장르"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_MOBILE_GENRE","Target Table","TV_TA_VOD_MOBILE_GENRE"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"idx","int ","idx","int "]
[null,"genre_cd","varchar(32) ","genre_cd","varchar(32) "]
[null,"genre_nm","varchar(32) ","genre_nm","varchar(32) "]

{"sheet":"TA_VOD_ORIGINAL","index":71,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스트리밍영화상품"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_ORIGINAL","Target Table","TV_TA_VOD_ORIGINAL"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"original_seq","int ","original_seq","int "]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"original_id","varchar(50) ","original_id","varchar(50) "]
[null,"type_cd","varchar(10) ","type_cd","varchar(10) "]
[null,"original_image","varchar(100) ","original_image","varchar(100) "]
[null,"original_link","varchar(100) ","original_link","varchar(100) "]
[null,"sdate","varchar(10) ","sdate","varchar(10) "]
[null,"edate","varchar(10) ","edate","varchar(10) "]
[null,"use_yn","varchar(1) ","use_yn","varchar(1) "]
[null,"reg_id","varchar(30) ","reg_id","varchar(30) "]
[null,"reg_dt","datetime ","reg_dt","datetime(3)"]

{"sheet":"TA_VOD_PHOTO","index":72,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스트리밍영화사진"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_PHOTO","Target Table","TV_TA_VOD_PHOTO"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"photo_id","int ","photo_id","int "]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"photo_cd","varchar(20) ","photo_cd","varchar(20) "]
[null,"thumb_file","varchar(200) ","thumb_file","varchar(200) "]
[null,"bigphoto_file","varchar(200) ","bigphoto_file","varchar(200) "]
[null,"title","varchar(100) ","title","varchar(100) "]
[null,"photo_grd","varchar(50) ","photo_grd","varchar(50) "]
[null,"default_yn","int ","default_yn","int "]
[null,"top_yn","int ","top_yn","int "]
[null,"mobile_poster_yn","varchar(1) ","mobile_poster_yn","char(1)"]
[null,"mobile_steal_yn","varchar(1) ","mobile_steal_yn","char(1)"]
[null,"use_yn","varchar(1) ","use_yn","char(1)"]

{"sheet":"TA_VOD_STAFF","index":73,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","스트리밍영화스탭"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_VOD_STAFF","Target Table","TV_TA_VOD_STAFF"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"staff_id","int ","staff_id","int "]
[null,"vod_id","varchar(20) ","vod_id","varchar(20) "]
[null,"per_id","int ","per_id","int "]
[null,"per_nm","varchar(100) ","per_nm","varchar(100) "]
[null,"staffs_cd","varchar(20) ","staffs_cd","varchar(20) "]
[null,"ord_key","int ","ord_key","int "]
[null,"use_yn","varchar(1) ","use_yn","char(1) "]
[null,"seq_person","int ","seq_person","int "]

{"sheet":"TA_M_DisplayContents","index":74,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,4,2,5],[3,4,3,5],[5,1,5,2],[5,3,5,4],[5,5,6,5]]}
[]
[null,"배치 명","메인배너 콘텐츠 디스플레이"]
[null,"Source Database","play24(yesvod)","Target Database","story24"]
[null,"Sourse Table","TA_M_DisplayContents","Target Table","TV_TA_M_DisplayContents"]
[]
[null,"source",null,"target",null,"비고"]
[null,"컬럼 명","DataType","컬럼 명","DataType"]
[null,"displaycontentsid","numeric(9) ","displaycontentsid","decimal(9,0)"]
[null,"displayregionid","varchar(50) ","displayregionid","varchar(50) "]
[null,"displaycontentsname","varchar(50) ","displaycontentsname","varchar(50) "]
[null,"linkurl","varchar(500) ","linkurl","varchar(500) "]
[null,"displaybegintime","date ","displaybegintime","date "]
[null,"displayendtime","date ","displayendtime","date "]
[null,"useyn","varchar(1) ","useyn","char(1)"]
[null,"contents","varchar(max) ","contents","varchar(4000)"]
[null,"sortorder","int ","sortorder","int "]
[null,"reg_dt","datetime ","reg_dt","datetime(3)"]
[null,"upt_dt","datetime ","upt_dt","datetime(3)"]
[null,"maintitle","varchar(100) ","maintitle","varchar(100) "]
[null,"subtitle","varchar(100) ","subtitle","varchar(100) "]

{"sheet":"Sheet4","index":75,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}